Introduction

This document contains the detailed analysis of historical NTD issues, as part of the Slalom Consulting project on Caltrans NTD Reporting Modernization. For a more concise summary of results without the code snippets, please see the accompanying powerpoint files from this project.

We analyze issues that were returned to Caltrans for resolution in 2020, 2021, and 2022 by their frequency, their issue type, and reporting agencies. We then derive the commonalities that could have triggered something being flagged by NTD. Finally, we curate the top 23 issues to target in a pre-submission validation tool, given these results.


Step 1: load in the data - 3 years of NTD issues from 3 different spreadsheets.

# getwd()
issues_2022 <- read_excel("~/Dev/caltrans/View Issues 9R02 Export_26-Jun-2023 05-51-58 PM.xlsx", sheet = "Sub-Recipient Issues",
                          skip = 1, .name_repair = "universal")
issues_2021 <- read_excel("~/Dev/caltrans/View Issues 9R02 Export_1-Jun-2022 11-04-44 PM FINAL.xlsx", sheet = "Sub-Recipient Issues",
                          skip = 1, .name_repair = "universal")
issues_2020 <- read_excel("~/Dev/caltrans/All Issues 9R02 Export 2021-05-18 FINAL (Rd4).xlsx", sheet = "Sub-Recipient Issues",
                          skip = 1, .name_repair = "universal")

After checking that all the columns are the same in each dataset, we combine everything into one dataset, adding a column for the year of the issue.

issues_2020 <- issues_2020 %>%
  mutate(year = as.integer(2020))
issues_2021 <- issues_2021 %>%
  mutate(year = as.integer(2021))
issues_2022 <- issues_2022 %>%
  mutate(year = as.integer(2022))

issues <- bind_rows(issues_2020, issues_2021, issues_2022) %>%
  relocate(year)
The first row of the combined issues dataset
year IssueId Reporter Reporter.Type Issue.Check.ID Form Mode Type.of.Service Description Resolution Criticality Status Comment.History Comment Decision
2020 2778796 60208 - Greyhound Lines, Inc.  Intercity Bus RR20IC-001 Reduced Reporting (RR-20) - Intercity Bus NA NA The value reported for 5311 (Rural) funding, {300,000}, is equal to the value reported in the prior year. Please revise FTA Other Than Urbanized Area (§5311) or provide an explanation for the data. Important Closed Okay per agency comment. - - 12/7/2020 1:13 PM GMT+00:00 The maximum amount awarded by Caltrans to 5311(f) subrecipients is $300,000 annually. This fund source amount is correct as shown; it is not rounded off. - - 11/3/2020 5:19 PM GMT+00:00 NA NA

Breakdown of Issues by Year

Three issues account for almost 25% of all validation flags in the past 3 years. 1. RR20F-005: The cost per hour changed by 30% or more. 2. A10-033: The number of General Purpose Maintenance Facilities differs from previous year. 3. RR20F-146: The miles per vehicle changed by 20% or more

Total Issues, 2020 - 2022
year n
2020 540
2021 579
2022 510

Yearly breakdown of Issues
Issue.Check.ID 2020 2021 2022 total
RR20F-005 33 39 23 95
A10-033 22 50 19 91
RR20F-146 27 22 41 90
A30-028 10 3 38 51
RR20F-001OA 12 22 17 51
RR20F-008 16 16 19 51
RR20F-070 5 23 12 40
RR20F-179 16 12 12 40
RR20F-139 8 9 22 39
A10-032 5 27 6 38
RR20F-066 10 14 13 37
RR20F-137 11 16 10 37
RR20F-154 10 9 18 37
RR20F-171 13 8 11 32
RR20F-001C 9 14 5 28
RR20F-180 6 5 14 25
RR20F-065 5 4 15 24
RR20F-010 1 10 10 21
RR20U-005 4 7 9 20
RR20F-182 6 8 3 17
RR20F-143 6 4 6 16
A30-041 7 5 2 14
RR20F-068 7 2 5 14
RR20F-168 7 3 4 14
RR20F-024 6 5 2 13
RR20U-001 6 2 5 13
A30-044 6 4 2 12
RR20F-127 4 4 4 12
RR20F-159 3 3 4 10
A30-038 3 6 NA 9
RR20F-173 4 4 1 9
RR20F-021 2 3 3 8
A30-029 3 2 2 7
RR20F-072 4 1 2 7
A10-035 1 3 2 6
A15-026 NA NA 5 5
B10-007 1 NA 4 5
RR20F-113 NA 3 2 5
A10-030 3 1 NA 4
RR20F-002 NA 3 1 4
RR20F-030 2 1 1 4
RR20F-060 NA 2 2 4
RR20F-148 NA 2 2 4
RR20F-164 3 NA 1 4
RR20F-166 NA 2 2 4
RR20F-069 1 1 1 3
RR20IC-001 1 1 1 3
A30-002 NA NA 2 2
A30-004 NA 2 NA 2
A30-066 NA 1 1 2
RR20F-012 NA NA 2 2
RR20F-016 1 NA 1 2
RR20F-025 NA 2 NA 2
RR20F-032 1 1 NA 2
RR20F-057 NA NA 2 2
RR20F-129 1 1 NA 2
RR20F-138 1 NA 1 2
RR20F-142 NA 1 1 2
RR20F-158 NA 1 1 2
RR20F-187 NA 2 NA 2
A30-005 NA NA 1 1
A30-036 NA 1 NA 1
A30-039 NA 1 NA 1
RR20F-013 NA 1 NA 1
RR20F-028 NA NA 1 1
RR20F-071 NA NA 1 1
RR20F-085 NA NA 1 1
RR20F-115 NA 1 NA 1
RR20F-134 NA 1 NA 1
RR20F-149 NA NA 1 1
RR20F-151 NA 1 NA 1
RR20F-161 1 NA NA 1

BY AGENCY

Validation flags are also clumped across certain agencies more than others.
Issues per Agency
Reporter 2020 2021 2022 total cumulative_pct
91089 - Tehama County 6 26 20 52 4.7
91027 - City of Arvin 23 6 13 42 8.4
91057 - Tuolumne County Transit 8 12 13 33 11.4
91090 - Morongo Basin Transit Authority 8 11 14 33 14.3
91009 - San Benito County LTA 3 15 12 30 17.0
91014 - City of Rio Vista 10 7 12 29 19.6
91116 - Alpine County Local Transportation Commission 4 14 11 29 22.2
99454 - Palo Verde Valley Transit Agency 13 8 8 29 24.8
91000 - Amador Regional Transit System 8 13 7 28 27.4
91110 - City of McFarland 7 13 7 27 29.8
91078 - City of Escalon 8 9 9 26 32.1
91038 - Sierra County Transportation Commission 9 12 4 25 34.3
91088 - Glenn Transit Service 3 13 9 25 36.6
90216 - County of Sacramento Municipal Services Agency Department of Transportation 6 10 8 24 38.7
91036 - Humboldt Transit Authority 8 10 6 24 40.9
91095 - Nevada County Transit Services 4 9 11 24 43.0
91047 - Mendocino Transit Authority 6 9 8 23 45.1
91048 - County of Siskiyou 6 7 10 23 47.2
91101 - Town of Truckee 3 15 5 23 49.2
91012 - Mountain Area Regional Transit Authority 5 8 9 22 51.2
91028 - City of Solvang 17 3 2 22 53.2
91062 - Eastern Sierra Transit Authority 8 9 5 22 55.2
91111 - City of California City 3 5 13 21 57.0
99442 - Calaveras Transit Agency 1 8 12 21 58.9
91066 - City of Taft 7 6 7 20 60.7
91120 - City of Shafter 5 7 8 20 62.5
99426 - Wasco, City of 8 6 6 20 64.3
91007 - Fresno County Rural Transit Agency 8 3 8 19 66.0
91041 - City of Dixon 9 8 2 19 67.7
91055 - Tulare County Area Transit 10 8 1 19 69.4
91008 - Modoc Transportation Agency 7 3 8 18 71.0
91018 - City of Arcata 8 5 5 18 72.6
91053 - Lake Transit Authority 3 8 7 18 74.3
91082 - Mariposa County Transit 2 7 9 18 75.9
91005 - Madera County 8 1 8 17 77.4
91006 - City of Ridgecrest 2 7 7 16 78.8
91093 - City of Eureka 8 3 5 16 80.3
91097 - Redwood Coast Transit Authority 4 12 NA 16 81.7
91059 - Kern Regional Transit 3 5 7 15 83.0
91043 - City of Guadalupe 3 6 5 14 84.3
91002 - City of Corcoran 2 3 8 13 85.5
91040 - City of Dinuba 7 6 NA 13 86.6
91058 - City of Ojai NA 6 7 13 87.8
91074 - City of Tehachapi 4 6 2 12 88.9
91035 - Trinity County 4 4 3 11 89.9
91098 - Lassen Transit Service Agency 3 3 5 11 90.9
91032 - City of Auburn 1 1 8 10 91.7
91112 - Colusa County Transit Agency 3 1 5 9 92.6
91119 - Plumas County Transportation Commission 2 2 5 9 93.4
90026 - San Diego Metropolitan Transit System 3 3 1 7 94.0
90079 - SunLine Transit Agency 1 3 3 7 94.6
91071 - City of Chowchilla 1 1 5 7 95.2
90226 - Imperial County Transportation Commission 1 2 1 4 95.6
91070 - Yosemite Area Regional Transportation System 1 NA 3 4 96.0
60208 - Greyhound Lines, Inc.  1 1 1 3 96.2
90013 - Santa Clara Valley Transportation Authority NA 2 1 3 96.5
90062 - Monterey-Salinas Transit NA 2 1 3 96.8
90087 - City of Santa Maria 2 NA 1 3 97.0
90089 - County of Sonoma NA 2 1 3 97.3
90121 - Antelope Valley Transit Authority 2 NA 1 3 97.6
90031 - Riverside Transit Agency NA NA 2 2 97.8
90061 - Yuba-Sutter Transit Authority NA NA 2 2 97.9
90144 - Livermore / Amador Valley Transit Authority NA NA 2 2 98.1
90162 - The Eastern Contra Costa Transit Authority NA 1 1 2 98.3
90198 - City of Porterville 2 NA NA 2 98.5
90200 - Kings County Area Public Transit Agency NA NA 2 2 98.7
90236 - Stanislaus County NA 2 NA 2 98.8
91020 - City of Needles NA NA 2 2 99.0
91079 - City of Woodlake NA 2 NA 2 99.2
90009 - San Mateo County Transit District 1 NA NA 1 99.3
90012 - San Joaquin Regional Transit District NA NA 1 1 99.4
90030 - North County Transit District 1 NA NA 1 99.5
90173 - Transit Joint Powers Authority for Merced County NA NA 1 1 99.6
90208 - Butte County Association of Governments NA NA 1 1 99.6
90303 - Santa Barbara County Association of Governments NA 1 NA 1 99.7
90310 - Tulare County Regional Transit Agency NA NA 1 1 99.8
99262 - Yurok Tribe NA 1 NA 1 99.9
99438 - County of Shasta Department of Public Works NA NA 1 1 100.0


Unique Issues

There are many, repeated errors to resolve, some clearly describing various transit types (e.g., DR - DO, DR - PT, MB, CB). Here we make a new “clean” description column by removing everything in brackets, for each Issue ID. * Streamline descriptions by removing all the numbers within brackets * tally

Further collapsed with the transport type stripped out.
Issues and their Generic Questions (combining transport type)
no. Issue.Check.ID descr_stripped n pct_total cumulative_pct
1 RR20F-005 The calculated cost per hour for {} Percent. 95 8.52 8.52
2 A10-033 Number of General Purpose Maintenance Facilities is {} last report year. 91 8.16 16.68
3 RR20F-146 The calculated miles per vehicle for {} caused by a change in Vehicle Revenue Miles, the number of Vehicles Operated in Annual Maximum Service, or both. 90 8.07 24.75
4 A30-028 RVI ID {} does not show any active vehicles in the fleet. If these vehicles were not part of the total fleet on the last day of the fiscal year, this fleet should be retired. If they were part of the total fleet but were not in active service, please verify this. 51 4.57 29.33
5 RR20F-001OA You reported $ {} for Total Operating Expenses by Source and did not report capital leasing expenses. These values must match. 51 4.57 33.90
6 RR20F-008 Fare Revenues per unlinked passenger trip {}. This change is high. 51 4.57 38.48
7 RR20F-070 The §5311 program is not listed as a revenue source in your report. 40 3.59 42.06
8 RR20F-179 One or more service data fields are are missing for {}. You must report miles, hours, trips and vehicles operated in maximum service (VOMS) if the transit unit operated revenue service during the fiscal year. 40 3.59 45.65
9 RR20F-139 For {}. This change is high. 39 3.50 49.15
10 A10-032 The total maintenance facilities {} you reported across all modes does not add up to a whole number. 38 3.41 52.56
11 RR20F-066 FTA Formula Grants for Rural Areas (5311), Funds Expended on Operations plus Capital is {} last report year. 37 3.32 55.87
12 RR20F-137 For {}. This change is high. 37 3.32 59.19
13 RR20F-154 The calculated trips per hour for {}. This change is high. 37 3.32 62.51
14 RR20F-171 For {} this year. 32 2.87 65.38
15 RR20F-001C The sum of Total Expenses for all modes {} for Uses of Capital. Total Expenses by Mode must equal the total of all funding source expenditures for capital purchases. 28 2.51 67.89
16 RR20F-180 The total Vehicles Operated in Annual Maximum Service on the RR-20 form {}. Please revise. 25 2.24 70.13
17 RR20F-065 FTA Formula Grants for Rural Areas (5311) {} is identical to last year’s report. This is unusual as financial data typically fluctuates from year to year. 24 2.15 72.29
18 RR20F-010 Fare Revenues, Funds Expended on Operations plus Capital is {} last report year. 21 1.88 74.17
19 RR20U-005 FTA Formula Grants for Rural Areas (§5311), Funds Expended on Operations plus Capital, is {} last report year. 20 1.79 75.96
20 RR20F-182 Sum of Funds Expended on Capital for all modes on the RR-20 form equals zero, but {} new fleets were reported as Owned Outright by Public Agency (OOPA). 17 1.52 77.49
21 RR20F-143 For {} last report year. 16 1.43 78.92
22 A30-041 RVI ID {}. 14 1.26 80.18
23 RR20F-068 FTA Formula Grants for Rural Areas (5311) appears to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 14 1.26 81.43
24 RR20F-168 For {} last report year. 14 1.26 82.69
25 RR20F-024 Local Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 13 1.17 83.86
26 RR20U-001 FTA Formula Grants for Rural Areas (5311) on the RR-20 Urban Recipient form {}. These values should match. 13 1.17 85.02
27 A30-044 RVI ID {} 12 1.08 86.10
28 RR20F-127 Other Federal Funds, Funds Expended on Operations plus Capital is {} last report year. 12 1.08 87.17
29 RR20F-159 For {} last report year. 10 0.90 88.07
30 A30-038 RVI ID {} feet, but you have reported the Vehicle Type as BU - bus. Usually, vehicles that are 22 feet or shorter are classified as VN - van. You should report these vehicles under the most applicable Vehicle Type or explain why they should be reported as buses. 9 0.81 88.88
31 RR20F-173 The number of incidents per mile is high compared to industry standards. Please confirm. 9 0.81 89.69
32 RR20F-021 Local Funds {} are identical to amount in last year’s report. This is unusual as financial data typically fluctuates from year to year. 8 0.72 90.40
33 A30-029 The Number of Active Vehicles in Fleet for RVI ID {} vehicles. This is an unusually high number. Please note that all vehicles in a fleet group must share the same type, length, seating capacity, year of manufacture, funding source and ownership type. 7 0.63 91.03
34 RR20F-072 5311 - capital assistance spent on operations is {} last report year. 7 0.63 91.66
35 A10-035 You have reported {} general purpose maintenance facilities. Please confirm the subrecipient owns/leases multiple maintenance facilities or revise the number. 6 0.54 92.20
36 A15-026 The TAM Facility Performance Measure Reporting Guidebook states: “New and updated regulations require transit agencies reporting to the NTD to include condition information on assets reported to the database. To satisfy this new requirement, the condition of each facility supporting transit operations must be reported to the NTD at least once every four years.” This means that any condition assessment completed during Report Year {} 5 0.45 92.65
37 B10-007 Organization Type in the current year - {}. 5 0.45 93.09
38 RR20F-113 Other FTA Funds, Funds Expended on Operations plus Capital is {} last report year. 5 0.45 93.54
39 A10-030 You did not report any general purpose maintenance facility. For DO modes, you must report any maintenance facilities owned or leased by you. For PT modes, you must report any maintenance facilities owned or leased by you or your contractors. 4 0.36 93.90
40 RR20F-002 You reported Total Expenses - Uses of Capital as less than $5,000, {}. This value is low. Capitalization levels include property with a useful life of more than one year and an acquisition cost of at least $5,000. Please describe the use of capital under $5,000 as well as how your capitalization requirements set by your governmnet unit differ from the FTA definition of capital. 4 0.36 94.26
41 RR20F-030 Other Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 4 0.36 94.62
42 RR20F-060 FTA Special Needs of Elderly Individuals and Individuals with Disabilities Formula Program (5310) appears to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 4 0.36 94.98
43 RR20F-148 Annual Vehicle Revenue Hours {} are identical to last year’s report. This is unusual as service data typically fluctuates from year to year. 4 0.36 95.34
44 RR20F-164 For {}. 4 0.36 95.70
45 RR20F-166 For {}. This change is high. 4 0.36 96.05
46 RR20F-069 The funds expended on §5311 program are equal to the Total Expenses. This grant program requires a match from state or local sources. 3 0.27 96.32
47 RR20IC-001 The value reported for 5311 (Rural) funding, {}, is equal to the value reported in the prior year. 3 0.27 96.59
48 A30-002 Number of Vehicles in Total Fleet is null for RVI ID {}. 2 0.18 96.77
49 A30-004 For RVI ID {}, Dedicated Fleet status is different from last report year. 2 0.18 96.95
50 A30-066 You listed RVI ID(s) {} as having been funded with Urbanized Area Formula Program (UA) funds.This is unusual, as this selection is reserved for 5307-funded vehicles in urbanized areas. 2 0.18 97.13
51 RR20F-012 Fare Revenues appear to be rounded to the nearest thousand. This is unusual as Fare Revenue should be exact data. 2 0.18 97.31
52 RR20F-016 Other Directly Generated Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 2 0.18 97.49
53 RR20F-025 State Funds {} are identical to last year’s report. This is unusual as financial data typically fluctuates from year to year. 2 0.18 97.67
54 RR20F-032 FTA Capital Investment Grants (§5309), Funds Expended on Operations plus Capital is {} last report year. 2 0.18 97.85
55 RR20F-057 FTA Special Needs of Elderly Individuals and Individuals with Disabilities Formula Program (§5310) ${} is identical to last report year. This is unusual as financial data typically fluctuates from year to year. 2 0.18 98.03
56 RR20F-129 Other Federal Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 2 0.18 98.21
57 RR20F-138 For {}. This is unusual. 2 0.18 98.39
58 RR20F-142 Annual Vehicle Revenue Miles {} are identical to last year’s report. This is unusual as service data typically fluctuates from year to year. 2 0.18 98.57
59 RR20F-158 Annual Unlinked Passenger Trips {} are identical to last year’s report. This is unusual as service data typically fluctuates from year to year. 2 0.18 98.74
60 RR20F-187 NTD ID {}. This is identical to the amount reported in the previous year. 2 0.18 98.92
61 A30-005 For {}. Most vehicles fit into existing vehicle type classifications. 1 0.09 99.01
62 A30-036 The Vehicle Length for RVI ID(s) {} is different from last year’s Vehicle Length. 1 0.09 99.10
63 A30-039 RVI ID {}. 1 0.09 99.19
64 RR20F-013 Other Directly Generated Funds {} are identical to last year’s report. This is unusual as financial data typically fluctuates from year to year. 1 0.09 99.28
65 RR20F-028 State Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 1 0.09 99.37
66 RR20F-071 5311 - capital assistance spent on operations ${} is identical to last report year. This is unusual as financial data typically fluctuates from year to year. 1 0.09 99.46
67 RR20F-085 FTA Tribal Transit funds (§5311), Funds Expended on Operations plus Capital is {} last report year. 1 0.09 99.55
68 RR20F-115 Other FTA Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 1 0.09 99.64
69 RR20F-134 The value you reported for {} this year or last year. 1 0.09 99.73
70 RR20F-149 For {} last report year. 1 0.09 99.82
71 RR20F-151 Annual Vehicle Revenue Hours for {} appear to be rounded to the nearest thousand. This is unusual as all service data should be reported as exact values. 1 0.09 99.91
72 RR20F-161 Annual Unlinked Passenger Trips appear to be rounded to the nearest thousand. This is unusual as all service data should be reported as exact values. 1 0.09 100.00

Deriving NTD flags

This section contains the code for finding the min/max range of top validation flags. We inspect each of the top 23 by inputting the Issue ID below and inspecting the results.

error = "RR20F-143"
single_issue <- issues %>% filter(Issue.Check.ID==error)
# # If all numbers
# min_max <- single_issue %>%
#   mutate(
#     numbers = str_extract_all(Description, "(?<=\\{)\\S*(?=\\})"),
#     percent_chr = map_chr(numbers, 1),
#     percent = as.double(str_remove(percent_chr, ","), na.rm=TRUE)
#   ) %>%
#   relocate(percent, .before = numbers)

# # If sub-categories
# min_max <- single_issue %>%
#   mutate( 
#     entries = str_extract_all(Description, "(?<=\\{)\\S*(?=\\})"), 
#     category_chr = map_chr(entries, first),
#     pct_chr = map_chr(entries, 2),
#     percent = as.double(str_remove(pct_chr, ","))) %>%
#   relocate(percent, .before = entries) %>%
#   relocate(category_chr, .before = percent)

# If one needs to calculate the percentage from 2 numbers
min_max <- single_issue %>%
   mutate(
     numbers = str_extract_all(Description, "(?<=\\{)\\S*(?=\\})"),
     thisyr = as.double(map_chr(numbers, 1), na.rm = TRUE),
     lastyr = as.double(map_chr(numbers, 2), na.rm=TRUE),
   percent = (thisyr/lastyr) - 1
   ) %>%
   relocate(percent, .before = numbers)
min_max %>%
  # group_by(category_chr) %>%
  summarize(min = min(percent),
            max = max(percent),
            min_absolute = min(abs(percent)),
            max_absolute = max(abs(percent)),
            )

Validation issues with the longest conversational trail

This section investigates which issues are potentially the longest to resolve, inferred from whether they had the most back and forth in their comment history. These might not be the same issues that are greatest by volume, so we cross check for thoroughness.

comment_length <- issues_cleaned %>%
  mutate(
    n_comments = str_count(Comment.History, "GMT")
  ) %>%
  relocate(n_comments, .before = Comment.History)

comment_length %>%
  filter(!is.na(n_comments)) %>%
  group_by(n_comments, Issue.Check.ID, descr_stripped) %>%
  summarize(freq = n()) %>%
  arrange(desc(n_comments))
We look into which issues have a disproportionate share of back-and-forth, by counting the timestamps in the comment history column and summarizing in a new “n_comments” column.
n_comments freq Issue.Check.ID descr_stripped pct_of_issues pct_of_comments cumpct_comments cumpct_issues no.
10 1 RR20F-008 Fare Revenues per unlinked passenger trip {}. This change is high. 0.09 0.62 0.62 0.09 1
9 1 RR20F-005 The calculated cost per hour for {} Percent. 0.09 0.56 1.18 0.19 2
9 1 RR20F-008 Fare Revenues per unlinked passenger trip {}. This change is high. 0.09 0.56 1.74 0.28 3
9 2 RR20F-137 For {}. This change is high. 0.19 0.56 2.30 0.46 4
8 1 RR20F-010 Fare Revenues, Funds Expended on Operations plus Capital is {} last report year. 0.09 0.50 2.79 0.56 5
8 1 RR20F-137 For {}. This change is high. 0.09 0.50 3.29 0.65 6
8 1 RR20F-146 The calculated miles per vehicle for {} caused by a change in Vehicle Revenue Miles, the number of Vehicles Operated in Annual Maximum Service, or both. 0.09 0.50 3.79 0.74 7
8 1 RR20F-154 The calculated trips per hour for {}. This change is high. 0.09 0.50 4.28 0.84 8
8 1 RR20F-180 The total Vehicles Operated in Annual Maximum Service on the RR-20 form {}. Please revise. 0.09 0.50 4.78 0.93 9
7 1 A10-033 Number of General Purpose Maintenance Facilities is {} last report year. 0.09 0.43 5.21 1.02 10
7 1 RR20F-005 The calculated cost per hour for {} Percent. 0.09 0.43 5.65 1.11 11
7 1 RR20F-137 For {}. This change is high. 0.09 0.43 6.08 1.21 12
7 1 NA For DR/PT, you reported the same operating expenses as last year of $790,440. This is highly unusual. Please explain further. 0.09 0.43 6.52 1.30 13
7 1 NA

The total operating expenses per mode are allocated to each mode by exact percentages of the total. Agencies are to report actual expense per mode. Please revise.

Commuter Bus is 12% of the total Demand Response is 19% of the total Motor Bus is 69% of the total
0.09 0.43 6.95 1.39 14
7 1 NA You are reporting the maintenance facility as Leased by Public Agency for Service Provider, but last year this was reported as Owned by Public Agency for Service Provider. Please either explain the change or revise the two A-10 forms. 0.09 0.43 7.39 1.49 15
6 2 A30-002 Number of Vehicles in Total Fleet is null for RVI ID {}. 0.19 0.37 7.76 1.67 16
6 4 RR20F-005 The calculated cost per hour for {} Percent. 0.37 0.37 8.13 2.04 17
6 5 RR20F-008 Fare Revenues per unlinked passenger trip {}. This change is high. 0.46 0.37 8.50 2.51 18
6 1 RR20F-013 Other Directly Generated Funds {} are identical to last year’s report. This is unusual as financial data typically fluctuates from year to year. 0.09 0.37 8.88 2.60 19
6 3 RR20F-137 For {}. This change is high. 0.28 0.37 9.25 2.88 20
6 1 RR20F-139 For {}. This change is high. 0.09 0.37 9.62 2.97 21
6 1 RR20F-143 For {} last report year. 0.09 0.37 9.99 3.06 22
6 2 RR20F-154 The calculated trips per hour for {}. This change is high. 0.19 0.37 10.37 3.25 23
6 1 NA

Are the Bus and Cutaway targets transposed?

You are reporting a 100% target for Bus which indicates that all Buses will have met or exceeded their ULB next year, but you just added three new 2020 Buses this year.

You are reporting a 0% target for Cutaway which indicates that all Cutaways will be within their ULB next year, but all Cutaways look to be past their ULB next year.

Please explain these or revise.
0.09 0.37 10.74 3.34 24
6 1 NA FTA Formula Grants for Rural Areas ($171,909) and Cares Act Rural Area Program Funds ($134,831) from the subrecipient RR-20 Reduced Reporting Form does not equal FTA Formula Grants for Rural Areas ($0) and Cares Act Rural Area Program Funds ($0) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.37 11.11 3.44 25
6 1 NA Operating Expenses for DR/PT are (347,614). The prior year’s value is (212,050). This is a 63.9% increase. 0.09 0.37 11.48 3.53 26
6 1 NA Rev Accrued through PT agreement-Non NTD, Funds Expended on Operations (16,481) is populated in the current years report but was zero or null in last years report. 0.09 0.37 11.86 3.62 27
6 1 NA The Fare Revenues per mode (Passenger Paid and Organization Paid) are split by exact percentages of 19% for Demand Response and 81% for Motor Bus. Please revise to report actual Fare Revenues per mode. 0.09 0.37 12.23 3.71 28
6 1 NA

The subrecipient received a waiver last year due to reporting fare media that was purchased and not redeemed during the report year. It was stated that the fares were tracked, but the unredeemed fares were not removed.

This year the MB fares per passenger actually increased $2.40 to $2.97. We would assume that if the agency was able to remove unredeemed fare this year that the fare per passenger would decrease. Did the agency have the same issue as the prior year? Please explain or revise.
0.09 0.37 12.60 3.81 29
6 1 NA

You did not report a target for Administrative / Maintenance Facilities on the A-90 Form; however, you are reporting facilities with this type on the A-15 Form for which your agency has capital responsibility. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or revise the data.

In addition, please select N/A for the assets the agency does not have.
0.09 0.37 12.97 3.90 30
6 1 NA You reported Other Directly Generated Funds described as Dial A Ride Fares and Partnership funding. Please explain these sources further. 0.09 0.37 13.35 3.99 31
6 1 NA You reported a Minivan target of 0% this year, but all Minivans (100%) have met or exceeded their ULB. This indicates that you plan that all Minivans will come into a State of Good Repair next year. Please explain or revise. 0.09 0.37 13.72 4.09 32
6 1 NA You reported a performance target of 33.33% for Rolling Stock: BU - Bus. However, you reported 5 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2022, divided by the total number of vehicles with useful life benchmarks. So the target of 33.33% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.37 14.09 4.18 33
6 1 NA You reported a performance target of 42.86% for Rolling Stock: CU - Cutaway. However, you reported 6 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 42.86% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.37 14.46 4.27 34
6 1 NA You reported a target of 0% for trucks, but the two service vehicle trucks (1991 & 2001) are past their ULB and was not discussed in your narrative. Please explain the target or revise. 0.09 0.37 14.84 4.36 35
6 1 NA You reported an Automobile target of 0% for the 2005 service vehicle. This indicates that you plan that all Automobiles will come into a State of Good Repair next year, but the narrative does touch on this asset type. Please confirm this target is what you intend to report or revise. 0.09 0.37 15.21 4.46 36
5 1 A10-033 Number of General Purpose Maintenance Facilities is {} last report year. 0.09 0.31 15.52 4.55 37
5 3 RR20F-005 The calculated cost per hour for {} Percent. 0.28 0.31 15.83 4.83 38
5 1 RR20F-021 Local Funds {} are identical to amount in last year’s report. This is unusual as financial data typically fluctuates from year to year. 0.09 0.31 16.14 4.92 39
5 1 RR20F-137 For {}. This change is high. 0.09 0.31 16.45 5.01 40
5 1 RR20F-139 For {}. This change is high. 0.09 0.31 16.76 5.11 41
5 1 RR20F-146 The calculated miles per vehicle for {} caused by a change in Vehicle Revenue Miles, the number of Vehicles Operated in Annual Maximum Service, or both. 0.09 0.31 17.07 5.20 42
5 1 RR20F-154 The calculated trips per hour for {}. This change is high. 0.09 0.31 17.38 5.29 43
5 1 RR20U-005 FTA Formula Grants for Rural Areas (§5311), Funds Expended on Operations plus Capital, is {} last report year. 0.09 0.31 17.69 5.39 44
5 1 NA The MB/PT Organization Paid Fare Revenue increased 244% from $8,087 last year to $27,827 this year. Please explain this large increase when the total ridership was cut in half. 0.09 0.31 18.00 5.48 45
5 1 NA The MB/PT Passenger Paid Fare Revenue decreased 99% from $48,675 last year to just $598 this year. Please explain this large decrease. 0.09 0.31 18.31 5.57 46
5 1 NA You reported a new fleet to the DR A-30 form this year with two vehicles (391329), but only reported $41,297 in capital expenses. Is this correct or are capital expenses per mode transposed? 0.09 0.31 18.62 5.66 47
5 1 NA You reported a performance target of 0.00% for Rolling Stock: MV - Minivan. However, you reported 0 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2022, divided by the total number of vehicles with useful life benchmarks. So the target of 0.00% does not seem to be logical. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.31 18.93 5.76 48
4 2 A10-033 Number of General Purpose Maintenance Facilities is {} last report year. 0.19 0.25 19.18 5.94 49
4 1 A15-026 The TAM Facility Performance Measure Reporting Guidebook states: “New and updated regulations require transit agencies reporting to the NTD to include condition information on assets reported to the database. To satisfy this new requirement, the condition of each facility supporting transit operations must be reported to the NTD at least once every four years.” This means that any condition assessment completed during Report Year {} 0.09 0.25 19.43 6.04 50
4 1 A30-028 RVI ID {} does not show any active vehicles in the fleet. If these vehicles were not part of the total fleet on the last day of the fiscal year, this fleet should be retired. If they were part of the total fleet but were not in active service, please verify this. 0.09 0.25 19.68 6.13 51
4 1 B10-007 Organization Type in the current year - {}. 0.09 0.25 19.93 6.22 52
4 25 RR20F-005 The calculated cost per hour for {} Percent. 2.32 0.25 20.17 8.54 53
4 9 RR20F-008 Fare Revenues per unlinked passenger trip {}. This change is high. 0.84 0.25 20.42 9.38 54
4 1 RR20F-010 Fare Revenues, Funds Expended on Operations plus Capital is {} last report year. 0.09 0.25 20.67 9.47 55
4 1 RR20F-021 Local Funds {} are identical to amount in last year’s report. This is unusual as financial data typically fluctuates from year to year. 0.09 0.25 20.92 9.56 56
4 2 RR20F-065 FTA Formula Grants for Rural Areas (5311) {} is identical to last year’s report. This is unusual as financial data typically fluctuates from year to year. 0.19 0.25 21.17 9.75 57
4 2 RR20F-070 The §5311 program is not listed as a revenue source in your report. 0.19 0.25 21.42 9.94 58
4 1 RR20F-071 5311 - capital assistance spent on operations ${} is identical to last report year. This is unusual as financial data typically fluctuates from year to year. 0.09 0.25 21.66 10.03 59
4 1 RR20F-072 5311 - capital assistance spent on operations is {} last report year. 0.09 0.25 21.91 10.12 60
4 1 RR20F-127 Other Federal Funds, Funds Expended on Operations plus Capital is {} last report year. 0.09 0.25 22.16 10.21 61
4 6 RR20F-137 For {}. This change is high. 0.56 0.25 22.41 10.77 62
4 4 RR20F-139 For {}. This change is high. 0.37 0.25 22.66 11.14 63
4 2 RR20F-143 For {} last report year. 0.19 0.25 22.91 11.33 64
4 9 RR20F-146 The calculated miles per vehicle for {} caused by a change in Vehicle Revenue Miles, the number of Vehicles Operated in Annual Maximum Service, or both. 0.84 0.25 23.15 12.16 65
4 1 RR20F-151 Annual Vehicle Revenue Hours for {} appear to be rounded to the nearest thousand. This is unusual as all service data should be reported as exact values. 0.09 0.25 23.40 12.26 66
4 1 RR20F-154 The calculated trips per hour for {}. This change is high. 0.09 0.25 23.65 12.35 67
4 4 RR20F-173 The number of incidents per mile is high compared to industry standards. Please confirm. 0.37 0.25 23.90 12.72 68
4 1 RR20F-180 The total Vehicles Operated in Annual Maximum Service on the RR-20 form {}. Please revise. 0.09 0.25 24.15 12.81 69
4 3 RR20F-182 Sum of Funds Expended on Capital for all modes on the RR-20 form equals zero, but {} new fleets were reported as Owned Outright by Public Agency (OOPA). 0.28 0.25 24.39 13.09 70
4 1 RR20F-187 NTD ID {}. This is identical to the amount reported in the previous year. 0.09 0.25 24.64 13.18 71
4 1 RR20U-001 FTA Formula Grants for Rural Areas (5311) on the RR-20 Urban Recipient form {}. These values should match. 0.09 0.25 24.89 13.28 72
4 1 RR20U-005 FTA Formula Grants for Rural Areas (§5311), Funds Expended on Operations plus Capital, is {} last report year. 0.09 0.25 25.14 13.37 73
4 1 NA A15-008 - You reported a Condition Assessment of 2, Marginal for Facility ID18788, PVVTA Maintenance Utility Shop; however, the year built or reconstructed as new (2014) indicates this facility is 8 years old. This is unusual. Please provide an explanation or revise the data if needed. 0.09 0.25 25.39 13.46 74
4 1 NA A15-022 - For Facility 9112 - Crossroads Plaza Park & Ride, you reported a condition of 4 last year and 2 this year, but did not report that you performed a new condition assessment. Please enter the date of the new condition assessment, revise the condition assessment, or explain why the reported condition changed even though the facility was not re-assessed. 0.09 0.25 25.64 13.56 75
4 1 NA A15-022 - For Facility 9113 - Escalon Park & Ride, you reported a condition of 4 last year and 2 this year, but did not report that you performed a new condition assessment. Please enter the date of the new condition assessment, revise the condition assessment, or explain why the reported condition changed even though the facility was not re-assessed. 0.09 0.25 25.88 13.65 76
4 1 NA A90-009 - You did not report a target for Automobiles on the A-90 Form; however, you are reporting service vehicle fleets with the vehicle type on the A-35 Form. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or update the data on the associated form. 0.09 0.25 26.13 13.74 77
4 1 NA A90-011 - You did not report a target for Passenger / Parking Facilities on the A-90 Form; however, you are reporting facilities with this type on the A-15 Form for which your agency has capital responsibility. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.25 26.38 13.83 78
4 1 NA A90-023 - You reported a performance target of 70.00% for Equipment: Trucks and other Rubber Tire Vehicles. However, you reported 3 service vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 70.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.25 26.63 13.93 79
4 1 NA Both the operating and capital expenses per mode look to be allocated by the percentage of VRH per mode. Please revise to show actual expenses per mode. 0.09 0.25 26.88 14.02 80
4 1 NA Cares Act Rural Area Program Funds ($392,226) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds($670,956) on the Urban form. The difference of $278,730 is being reported to the CRSSA Act line item for the subrecipient. These values should match. Please explain or revise the data. 0.09 0.25 27.13 14.11 81
4 1 NA Cares Act Rural Area Program Funds (§5311) ($81,816) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds (§5311) Funds Expended on Operations ($0) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.25 27.37 14.21 82
4 1 NA For CB/DO, you reported Funds Expended on Capital ($978) less than $5,000. This value is low, as the capitalization threshold is usually $5,000. Please explain or revise. 0.09 0.25 27.62 14.30 83
4 1 NA For DR/PT, you reported Funds Expended on Capital ($4,279) less than $5,000. This value is low, as the capitalization threshold is usually $5,000. Please explain or revise. 0.09 0.25 27.87 14.39 84
4 1 NA For Facility 8737 - Transit Building, you reported a condition of 4 last year and 3 this year, but did not report that you performed a new condition assessment. Please enter the date of the new condition assessment, revise the condition assessment, or explain why the reported condition changed even though the facility was not re-assessed. 0.09 0.25 28.12 14.48 85
4 1 NA For MB/PT, Annual Vehicle Revenue Miles increased 11.9% compared to last year from (87,911) to (98,381). This change is outside the expected range, given the impact of the COVID-19 public health emergency on most transit systems. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.25 28.37 14.58 86
4 1 NA None of the service vehicles are listed as servicing all three modes. Please list the additional secondary mode if any of these are utilized by all mode or confirm what is reported is correct. 0.09 0.25 28.62 14.67 87
4 1 NA Operating Expenses for DR/PT are (245,922). The prior year’s value is (470,688). This is a -47.8% decrease. 0.09 0.25 28.86 14.76 88
4 1 NA Operating Expenses for MB/DO are (3,353,473). The prior year’s value is (2,344,937). This is a 43.0% increase. 0.09 0.25 29.11 14.86 89
4 1 NA Please describe the Other Funds reported. 0.09 0.25 29.36 14.95 90
4 1 NA Please provide a description for the Other Directly Generated Funds. 0.09 0.25 29.61 15.04 91
4 1 NA Please provide a description of the funds reported in Other Funds. 0.09 0.25 29.86 15.13 92
4 1 NA Please select NA for the assets the agency does not have. 0.09 0.25 30.11 15.23 93
4 1 NA RR20F-139 - For DR/PT, Annual Vehicle Revenue Miles decreased -33.2% compared to last year from 302,308 to 201,947. This change is outside the expected range, given the impact of the COVID-19 public health emergency on most transit systems. Please provide an explanation or revise the data if needed. 0.09 0.25 30.35 15.32 94
4 1 NA RR20F-182 - The sum of Funds Expended on Capital for all modes on the RR-20 form is $0, but the sum of total vehicles for all modes (17) is greater than last year (13). Please provide an explanation for why this agency reported new vehicles without any capital expenses, or revise the data if needed. 0.09 0.25 30.60 15.41 95
4 1 NA RR20F-185 - For MB/PT, Vehicle Revenue Hours (8,147) decreased by 28.62% from last year’s value (11,413) while Vehicle Revenue Miles (239,072) increased by 15.23% from last year’s value (207,467). This is unusual, as miles and hours typically increase or decrease together. Please provide an explanation or revise the data if needed. 0.09 0.25 30.85 15.51 96
4 1 NA RR20F-199 - For CB/DO, you reported $4,947 under Funds Expended on Capital. This is lower than the typical capitalization threshold of $5,000. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.25 31.10 15.60 97
4 1 NA RR20F-237 - You reported $0 under Organization-Paid Fares, Funds Expended on Operations, last report year. However, you reported $5,721 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed. 0.09 0.25 31.35 15.69 98
4 1 NA RR20F-237 - You reported $139,430 under Organization-Paid Fares, Funds Expended on Operations, last Report Year. However, you reported $0 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed. 0.09 0.25 31.60 15.78 99
4 1 NA Rev Accrued through PT agreement-Non NTD, Funds Expended on Capital (245,895) is populated in the current years report but was zero or null in last years report. 0.09 0.25 31.84 15.88 100
4 1 NA The DR/DO Fare Revenue per UPT is exactly $1, which is the same as last year. Did all passengers pay exactly $1 with no reduced fare riders? Per the website, there are multiple fare options. 0.09 0.25 32.09 15.97 101
4 1 NA The DR/PT Fare Revenue per Passenger this year ($1.15) decreased 51% since last year ($2.37). This was caused by the ridership decreasing 32% but the passenger fares decreasing 67%. Please explain this fluctuation or revise. 0.09 0.25 32.34 16.06 102
4 1 NA The DR/PT ridership decreased 44% since last year, but the Vehicle Revenue Hours only decreased 0.25%. This is unusual. Please explain or revise. 0.09 0.25 32.59 16.16 103
4 1 NA The MB Fares per Passenger equals $20.69. This seems high. Please explain the fares charged for the MB service or revise. 0.09 0.25 32.84 16.25 104
4 1 NA The MB/PT Fare Revenue per Passenger this year ($2.98) increased 69% since last year ($1.77). This was caused by the ridership decreasing 67% but the passenger fares only decreasing 45%. Please explain this fluctuation or revise. 0.09 0.25 33.09 16.34 105
4 1 NA The Vehicles Operated in Annual Maximum Service (VOMS) for the MB/DO mode decreased from 5 last year to 3 this year. VOMS represents the max number of vehicles used to operate service simultaneously once during the year. Please confirm that three is correct or revise. 0.09 0.25 33.33 16.43 106
4 1 NA The calculated cost per mile for DR/DO equals ($9.06) for the current report year and equals ($6.18) in the previous report year. That is a (46.60%) change, which is high. Cost per mile is the operating expenses by mode divided by VRM on the RR-20. Please explain or revise the data. 0.09 0.25 33.58 16.53 107
4 1 NA The calculated cost per mile for DR/PT equals ($13.19) for the current report year and equals ($9.14) in the previous report year. That is a (44.31%) change, which is high. Cost per mile is the operating expenses by mode divided by VRM on the RR-20. Please explain or revise the data. 0.09 0.25 33.83 16.62 108
4 1 NA The fares per passenger this year ($7.34) decreased 61% since last year ($19.01). This was caused by the passengers decreasing by 96 riders, but the passenger paid fares increasing 286%, from $1,063 to $4,098 and not reporting organization paid fares. Please explain or revise. 0.09 0.25 34.08 16.71 109
4 1 NA The narrative report mentions replacing three Cutaways in this reporting period and adding another Van, but no new fleets were added to the report this year. Please explain or revise. 0.09 0.25 34.33 16.81 110
4 1 NA

The subrecipient received a waiver last year due to reporting fare media that was purchased and not redeemed during the report year. It was stated that the fares were tracked, but the unredeemed fares were not fully removed.

Please explain their situation from FY21 and if they were able to fix the issue.
0.09 0.25 34.57 16.90 111
4 1 NA You added a new truck to the A-35 form this year, but did not report any capital expense on the RR-20. Please explain or revise. 0.09 0.25 34.82 16.99 112
4 1 NA You appear to have reported FTA funds under Other Funds in the Non-Federal Funds section. Please report these under Other FTA Funds in the Federal Funds section. 0.09 0.25 35.07 17.08 113
4 1 NA You are reporting one maintenance facility that is Leased by Public Agency for Service Provider, but last year this was reported as Owned by Public Agency for Service Provider. Please explain or revise. 0.09 0.25 35.32 17.18 114
4 1 NA

You are reporting one maintenance facility this year solely under the CB/DO mode.

  1. Please explain this new maintenance facility that you are reporting this year. You labeled this as a Bus Yard. Is this even a facility?
  2. If this is utilized by all three modes, please allocate the facility between all A-10 forms.
  3. Please determine the Primary and Secondary modes based on the allocation percentage.
0.09 0.25 35.57 17.27 115
4 1 NA You did not report a target for Van on the A-90 Form; however, you are reporting revenue vehicle fleets with this vehicle type of the A-30 Form. Please provide an explanation or revise the data. 0.09 0.25 35.82 17.36 116
4 1 NA You did not report any passenger paid fare revenues this year, yet report a large increase in organization paid fare revenues of 60%. Please explain this further. 0.09 0.25 36.06 17.46 117
4 1 NA You have reported a useful life benchmark of 14 for Automobiles Fleets 13585, 13584, 13582, 13581, 13580, which is outside of the expected tolerance. Please confirm this is the expected lifecycle of this asset in your agency’s operating environment. 0.09 0.25 36.31 17.55 118
4 1 NA You have reported your operating expenses per mode at exact percentages of 23% and 77%. You also did the same thing last year with the exact same percentage split between modes. Agencies are required to report actual expenses per mode. Please revise to show the actual expenses per mode or explain. 0.09 0.25 36.56 17.64 119
4 1 NA You inserted a target for Van of 100%, but the performance for Vans is 0%. This indicates that you believe that all four 2014 Vans will come out of a State of Good Repair by 2021. Please confirm this is what you intended to report or revise. 0.09 0.25 36.81 17.73 120
4 1 NA You reported 1 facility with capital responsibility; however, 0 facilities have condition assessments reported. For 2021, you are required to report condition assessments for 100% of the facilities for which you have capital responsibility. Please provide an explanation or revise the data. 0.09 0.25 37.06 17.83 121
4 1 NA You reported Cares Act Public Transportation on Indian Reservations Program Funds (§5311) ($1,736,289) on the RR-20 form rather than on the CARES Act Rural Area Program Funds (§5311) line. In addition, the Urban report does not have any CARES funding reported. These values should match. Please explain or revise the data. 0.09 0.25 37.31 17.92 122
4 1 NA You reported Other Funds ($71) in the Non-Federal Funding Data, Funds Expended on Operations section. Please verify that these funds should not be reported on a different funding source line. Please revise the data or explain. 0.09 0.25 37.55 18.01 123
4 1 NA You reported Other Funds described as Advertising Revenue. Please move this to Other Directly Generated Funds. 0.09 0.25 37.80 18.11 124
4 1 NA You reported Other Funds described as BWE Contributions, CNG Fuels Sales and Proceeds from sale of fixed assets. Please report the fuel sales and proceeds to Other Directly Generated. In addition, please describe the BWE Contributions further. 0.09 0.25 38.05 18.20 125
4 1 NA You reported Other Funds described as Municipality service agreements – Mono County, Mariposa County, Fresno County, & Merced County. Please explain these further. 0.09 0.25 38.30 18.29 126
4 1 NA You reported Other Funds described as the following: Interest, Insurance Proceeds, Cash Overage, Prior period adj and Service to Other Depts.

Please report the Interest and Insurance Proceeds to Other Directly Generated. Please report the Cash Overage to Local Funds if this is an internal account. If not, please explain.

Lastly, please explain the Prior Period Adj and Service to Other Depts further.
0.09 0.25 38.55 18.38 127
4 1 NA You reported a Cutaway target of 16.67% this year, but this year 83.33% of all Cutaways have met or exceeded their ULB. This indicates that you plan on 66.66% of the Cutaways will come into a State of Good Repair next year. Please explain or revise. 0.09 0.25 38.80 18.48 128
4 1 NA

You reported a large increase in bus organization paid fares this year. Please explain or revise.

2019: $39,542 2020: $108,066
0.09 0.25 39.04 18.57 129
4 1 NA You reported a new fleet to the MB A-30 form (392639) but did not report any capital expense to the MB mode on the RR-20 form. Please explain or revise. 0.09 0.25 39.29 18.66 130
4 1 NA You reported a performance target of 11.11% for Rolling Stock: CU - Cutaway. However, you reported 6 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 11.11% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.25 39.54 18.76 131
4 1 NA You reported a performance target of 25.00% for Rolling Stock: CU - Cutaway. However, you reported 7 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 25.00% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.25 39.79 18.85 132
4 1 NA You reported a performance target of 33.33% for Rolling Stock: BU - Bus. However, you only have 2 active buses on the A-30 form. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 33.33% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.25 40.04 18.94 133
4 1 NA You reported a target for Automobiles but the service vehicle you reported on the A-35 is identified as a Truck and Other Rubber Tire vehicle. Please revise the target to that line item and select N/A for that asset. In addition, the narrative report has this listed under Automobile as well. Please revise the narrative to show this under Truck and Other Rubber Tire vehicle. 0.09 0.25 40.29 19.03 134
4 1 NA You reported a target for Minivan on the A-90 Form; however, you are not reporting revenue vehicles with this vehicle type on the A-30 Form. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.25 40.53 19.13 135
4 1 NA You reported a target for Steel Wheel Vehicles on the A-90 Form; however, you are not reporting service vehicles with this vehicle type on the A-35 Form. Please provide an explanation or revise the data. 0.09 0.25 40.78 19.22 136
4 1 NA You reported a target for Trucks and other Rubber Tire Vehicles on the A-90 Form; however, you are not reporting service vehicles with this vehicle type on the A-35 Form. Please provide an explanation or revise the data. 0.09 0.25 41.03 19.31 137
4 1 NA You reported a target of 0% for Automobiles, but the one service vehicle automobile (1995) is past its ULB and was not discussed in your narrative. Please explain the target or revise. 0.09 0.25 41.28 19.41 138
4 1 NA You reported four new fleets this year with RAFP funding (392648, 392649, 392650, 392651), but no 5311 funds were reported for capital on the RR-20. If these were purchased with Non Federal funds, please revise to NFPA. If they were purchased with 5311, please revise the RR-20. 0.09 0.25 41.53 19.50 139
4 1 NA You reported one maintenance facility as Leased from a Private Entity this year, but last year this was reported as Owned. Please explain or revise. 0.09 0.25 41.78 19.59 140
4 1 NA You reported organization paid fares this year for the first time. Please explain these or revise. 0.09 0.25 42.02 19.68 141
4 1 NA You reported the Automobile target of 0% in the Rolling Stock section of the A-90, but the 2002 Automobile on the A-30 form has met its useful life. Please explain or revise. 0.09 0.25 42.27 19.78 142
4 1 NA You reported two new fleets with the funding source of RAFP (741 and 742) but no 5311 funds are reported on the RR-20. Please either revise the funding source or revise the RR-20. 0.09 0.25 42.52 19.87 143
4 1 NA You stated the Minivan target is 0% but the one Minivan reported is past its useful life. Please explain or revise. 0.09 0.25 42.77 19.96 144
3 3 A10-033 Number of General Purpose Maintenance Facilities is {} last report year. 0.28 0.19 42.95 20.24 145
3 2 A30-028 RVI ID {} does not show any active vehicles in the fleet. If these vehicles were not part of the total fleet on the last day of the fiscal year, this fleet should be retired. If they were part of the total fleet but were not in active service, please verify this. 0.19 0.19 43.14 20.43 146
3 1 RR20F-005 The calculated cost per hour for {} Percent. 0.09 0.19 43.33 20.52 147
3 2 RR20F-008 Fare Revenues per unlinked passenger trip {}. This change is high. 0.19 0.19 43.51 20.71 148
3 1 RR20F-010 Fare Revenues, Funds Expended on Operations plus Capital is {} last report year. 0.09 0.19 43.70 20.80 149
3 1 RR20F-021 Local Funds {} are identical to amount in last year’s report. This is unusual as financial data typically fluctuates from year to year. 0.09 0.19 43.89 20.89 150
3 2 RR20F-024 Local Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 0.19 0.19 44.07 21.08 151
3 1 RR20F-065 FTA Formula Grants for Rural Areas (5311) {} is identical to last year’s report. This is unusual as financial data typically fluctuates from year to year. 0.09 0.19 44.26 21.17 152
3 1 RR20F-066 FTA Formula Grants for Rural Areas (5311), Funds Expended on Operations plus Capital is {} last report year. 0.09 0.19 44.44 21.26 153
3 1 RR20F-068 FTA Formula Grants for Rural Areas (5311) appears to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 0.09 0.19 44.63 21.36 154
3 2 RR20F-070 The §5311 program is not listed as a revenue source in your report. 0.19 0.19 44.82 21.54 155
3 1 RR20F-139 For {}. This change is high. 0.09 0.19 45.00 21.63 156
3 1 RR20F-146 The calculated miles per vehicle for {} caused by a change in Vehicle Revenue Miles, the number of Vehicles Operated in Annual Maximum Service, or both. 0.09 0.19 45.19 21.73 157
3 1 RR20F-154 The calculated trips per hour for {}. This change is high. 0.09 0.19 45.38 21.82 158
3 1 NA Cares Act Rural Area Program Funds (§5311) ($0) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds (§5311) Funds Expended on Operations ($130,000) on the Urban form. These values should match. It looks like all funds were included in the 5311 amount and not split. Please explain or revise. 0.09 0.19 45.56 21.91 159
3 1 NA For Facility 18788 - Transit, you reported a condition of 5 last year and 4 this year, but did not report that you performed a new condition assessment. Please enter the date of the new condition assessment, revise the condition assessment, or explain why the reported condition changed even though the facility was not re-assessed. 0.09 0.19 45.75 22.01 160
3 1 NA Operating Expenses for DR/PT are (566,095). The prior year’s value is (378,918). This is a 49.4% increase. 0.09 0.19 45.93 22.10 161
3 1 NA Please select NA for the assets the agency does not have. 0.09 0.19 46.12 22.19 162
3 1 NA

This agency reported $400,000 under CARES Act Urbanized Area Program Funds (§5307) in their direct urban report.

This agency’s rural subrecipient report reflects $400,000 under CARES Act Rural Area Program Funds (§5311).

Please coordinate with this agency to determine the correct funding source for these funds, or revise the data if needed.
0.09 0.19 46.31 22.28 163
3 1 NA You removed MB/DO service and added DR/PT and MB/PT. Please explain. 0.09 0.19 46.49 22.38 164
3 1 NA You reported Other Funds ($20,000) in the Non-Federal Funding Data, Funds Expended on Operations section. Please verify that these funds should not be reported on a different funding source line. Please revise the data or explain. 0.09 0.19 46.68 22.47 165
3 1 NA You reported a target for Minivan on the A-90 Form; however, you are not reporting revenue vehicles with this vehicle type on the A-30 Form with capital responsibility. Please provide an explanation or revise the data. 0.09 0.19 46.87 22.56 166
2 4 A10-030 You did not report any general purpose maintenance facility. For DO modes, you must report any maintenance facilities owned or leased by you. For PT modes, you must report any maintenance facilities owned or leased by you or your contractors. 0.37 0.12 46.99 22.93 167
2 3 A10-032 The total maintenance facilities {} you reported across all modes does not add up to a whole number. 0.28 0.12 47.11 23.21 168
2 13 A10-033 Number of General Purpose Maintenance Facilities is {} last report year. 1.21 0.12 47.24 24.42 169
2 3 A10-035 You have reported {} general purpose maintenance facilities. Please confirm the subrecipient owns/leases multiple maintenance facilities or revise the number. 0.28 0.12 47.36 24.70 170
2 1 A15-026 The TAM Facility Performance Measure Reporting Guidebook states: “New and updated regulations require transit agencies reporting to the NTD to include condition information on assets reported to the database. To satisfy this new requirement, the condition of each facility supporting transit operations must be reported to the NTD at least once every four years.” This means that any condition assessment completed during Report Year {} 0.09 0.12 47.49 24.79 171
2 2 A30-004 For RVI ID {}, Dedicated Fleet status is different from last report year. 0.19 0.12 47.61 24.98 172
2 23 A30-028 RVI ID {} does not show any active vehicles in the fleet. If these vehicles were not part of the total fleet on the last day of the fiscal year, this fleet should be retired. If they were part of the total fleet but were not in active service, please verify this. 2.14 0.12 47.73 27.11 173
2 6 A30-029 The Number of Active Vehicles in Fleet for RVI ID {} vehicles. This is an unusually high number. Please note that all vehicles in a fleet group must share the same type, length, seating capacity, year of manufacture, funding source and ownership type. 0.56 0.12 47.86 27.67 174
2 2 A30-041 RVI ID {}. 0.19 0.12 47.98 27.86 175
2 1 A30-044 RVI ID {} 0.09 0.12 48.11 27.95 176
2 2 B10-007 Organization Type in the current year - {}. 0.19 0.12 48.23 28.13 177
2 1 RR20F-001OA You reported $ {} for Total Operating Expenses by Source and did not report capital leasing expenses. These values must match. 0.09 0.12 48.36 28.23 178
2 4 RR20F-002 You reported Total Expenses - Uses of Capital as less than $5,000, {}. This value is low. Capitalization levels include property with a useful life of more than one year and an acquisition cost of at least $5,000. Please describe the use of capital under $5,000 as well as how your capitalization requirements set by your governmnet unit differ from the FTA definition of capital. 0.37 0.12 48.48 28.60 179
2 42 RR20F-005 The calculated cost per hour for {} Percent. 3.90 0.12 48.60 32.50 180
2 18 RR20F-008 Fare Revenues per unlinked passenger trip {}. This change is high. 1.67 0.12 48.73 34.17 181
2 12 RR20F-010 Fare Revenues, Funds Expended on Operations plus Capital is {} last report year. 1.11 0.12 48.85 35.28 182
2 1 RR20F-012 Fare Revenues appear to be rounded to the nearest thousand. This is unusual as Fare Revenue should be exact data. 0.09 0.12 48.98 35.38 183
2 2 RR20F-016 Other Directly Generated Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 0.19 0.12 49.10 35.56 184
2 4 RR20F-021 Local Funds {} are identical to amount in last year’s report. This is unusual as financial data typically fluctuates from year to year. 0.37 0.12 49.22 35.93 185
2 9 RR20F-024 Local Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 0.84 0.12 49.35 36.77 186
2 1 RR20F-028 State Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 0.09 0.12 49.47 36.86 187
2 4 RR20F-030 Other Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 0.37 0.12 49.60 37.23 188
2 2 RR20F-032 FTA Capital Investment Grants (§5309), Funds Expended on Operations plus Capital is {} last report year. 0.19 0.12 49.72 37.42 189
2 2 RR20F-057 FTA Special Needs of Elderly Individuals and Individuals with Disabilities Formula Program (§5310) ${} is identical to last report year. This is unusual as financial data typically fluctuates from year to year. 0.19 0.12 49.84 37.60 190
2 4 RR20F-060 FTA Special Needs of Elderly Individuals and Individuals with Disabilities Formula Program (5310) appears to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 0.37 0.12 49.97 37.98 191
2 12 RR20F-065 FTA Formula Grants for Rural Areas (5311) {} is identical to last year’s report. This is unusual as financial data typically fluctuates from year to year. 1.11 0.12 50.09 39.09 192
2 19 RR20F-066 FTA Formula Grants for Rural Areas (5311), Funds Expended on Operations plus Capital is {} last report year. 1.76 0.12 50.22 40.85 193
2 12 RR20F-068 FTA Formula Grants for Rural Areas (5311) appears to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 1.11 0.12 50.34 41.97 194
2 23 RR20F-070 The §5311 program is not listed as a revenue source in your report. 2.14 0.12 50.47 44.10 195
2 2 RR20F-072 5311 - capital assistance spent on operations is {} last report year. 0.19 0.12 50.59 44.29 196
2 2 RR20F-113 Other FTA Funds, Funds Expended on Operations plus Capital is {} last report year. 0.19 0.12 50.71 44.48 197
2 5 RR20F-127 Other Federal Funds, Funds Expended on Operations plus Capital is {} last report year. 0.46 0.12 50.84 44.94 198
2 1 RR20F-129 Other Federal Funds appear to be rounded to the nearest thousand. This is unusual as all financial information should be reported as exact values. 0.09 0.12 50.96 45.03 199
2 14 RR20F-137 For {}. This change is high. 1.30 0.12 51.09 46.33 200
2 1 RR20F-138 For {}. This is unusual. 0.09 0.12 51.21 46.43 201
2 27 RR20F-139 For {}. This change is high. 2.51 0.12 51.33 48.93 202
2 7 RR20F-143 For {} last report year. 0.65 0.12 51.46 49.58 203
2 43 RR20F-146 The calculated miles per vehicle for {} caused by a change in Vehicle Revenue Miles, the number of Vehicles Operated in Annual Maximum Service, or both. 3.99 0.12 51.58 53.57 204
2 18 RR20F-154 The calculated trips per hour for {}. This change is high. 1.67 0.12 51.71 55.25 205
2 1 RR20F-161 Annual Unlinked Passenger Trips appear to be rounded to the nearest thousand. This is unusual as all service data should be reported as exact values. 0.09 0.12 51.83 55.34 206
2 3 RR20F-164 For {}. 0.28 0.12 51.96 55.62 207
2 1 RR20F-166 For {}. This change is high. 0.09 0.12 52.08 55.71 208
2 6 RR20F-168 For {} last report year. 0.56 0.12 52.20 56.27 209
2 2 RR20F-171 For {} this year. 0.19 0.12 52.33 56.45 210
2 2 RR20F-173 The number of incidents per mile is high compared to industry standards. Please confirm. 0.19 0.12 52.45 56.64 211
2 1 RR20F-179 One or more service data fields are are missing for {}. You must report miles, hours, trips and vehicles operated in maximum service (VOMS) if the transit unit operated revenue service during the fiscal year. 0.09 0.12 52.58 56.73 212
2 3 RR20F-180 The total Vehicles Operated in Annual Maximum Service on the RR-20 form {}. Please revise. 0.28 0.12 52.70 57.01 213
2 6 RR20F-182 Sum of Funds Expended on Capital for all modes on the RR-20 form equals zero, but {} new fleets were reported as Owned Outright by Public Agency (OOPA). 0.56 0.12 52.82 57.57 214
2 3 RR20IC-001 The value reported for 5311 (Rural) funding, {}, is equal to the value reported in the prior year. 0.28 0.12 52.95 57.85 215
2 2 RR20U-001 FTA Formula Grants for Rural Areas (5311) on the RR-20 Urban Recipient form {}. These values should match. 0.19 0.12 53.07 58.03 216
2 15 RR20U-005 FTA Formula Grants for Rural Areas (§5311), Funds Expended on Operations plus Capital, is {} last report year. 1.39 0.12 53.20 59.42 217
2 1 NA

A10-036 - For this agency’s modes that have maintenance facilities allocated:

  • DR/PT vehicles account for 17.65% of total vehicles. The maintenance facilities allocated to this mode/type of service account for 75.00% of total maintenance facilities.
  • MB/PT vehicles account for 82.35% of total vehicles. The maintenance facilities allocated to this mode/type of service account for 25.00% of total maintenance facilities.
These percentages are usually similar. You may have transposed the values between modes. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below.
0.09 0.12 53.32 59.52 218
2 1 NA A15-008 - You reported a Condition Assessment of 5, Excellent for Facility ID 3552, Transit Depot; however, the year built or reconstructed as new (1998) indicates this facility is 24 years old. This is unusual. Additionally, last year you reported a Condition Assessment of 4. Please provide an explanation or revise the data if needed. 0.09 0.12 53.45 59.61 219
2 1 NA A15-015 - You have reported 30.00% Agency Capital Responsibility for Facility ID 20249, PVVTA Main Street Park N Ride. Reporting less than 100% indicates the capital responsibility is shared with another entity. Please complete the Notes section to describe this shared capital responsibility relationship, or revise the data if needed. 0.09 0.12 53.57 59.70 220
2 1 NA A15-015 - You have reported 33.30% as the Percent Agency Capital Responsibility for Facility ID 20246, Nevada County Operations Center, and stated in the Notes section that this facility is shared between three departments within the county. If this is a county-owned facility, please update Capital Responsibility to 100%. 0.09 0.12 53.69 59.80 221
2 1 NA A15-021 - You did not report a Secondary Mode for any facilities. Any facility that serves multiple modes should have a Secondary Mode or Modes selected. Please revise Secondary Mode where appropriate, or confirm that each of your facilities only serves one mode. 0.09 0.12 53.82 59.89 222
2 1 NA A15-023 - You added the following facilities to your A-15 form this year: 20117 - Electric Charging Station. Please provide an explanation for why this facility was added this year. 0.09 0.12 53.94 59.98 223
2 1 NA A15-023 - You added the following facilities to your A-15 form this year: 20241 - Mobile Office Trailer. Please briefly explain why you added this facility this year. 0.09 0.12 54.07 60.07 224
2 1 NA A15-023 - You added the following facilities to your A-15 form this year: 20248 - PVVTA Operations Center, 20249 - PVVTA Main Street Park N Ride, 20250 - Blythe CNG Station. Please explain why these facilities were added this year. 0.09 0.12 54.19 60.17 225
2 1 NA A15-023 - You added the following facility to your A-15 form this year: 20246 - Nevada County Operations Center. Please explain why this facility was added this year. 0.09 0.12 54.31 60.26 226
2 1 NA A30-062 - For CB/DO, Revenue Vehicle Inventory IDs 351937 and 351938, vehicle type changed from Bus last year to Cutaway this year. Vehicle Type typically does not change. Please provide an explanation for this change or revise the data if needed. 0.09 0.12 54.44 60.35 227
2 1 NA A30-062 - For DR/PT, Revenue Vehicle Inventory ID (373501), vehicle type changed from Sports Utility Vehicle last year to Automobile this year. Please provide an explanation for this change, or revise the data if needed. 0.09 0.12 54.56 60.45 228
2 1 NA A30-062 - For MB/PT, Revenue Vehicle Inventory ID (392558, 392559), vehicle type changed from Van last year to Cutaway this year. Please provide an explanation for this change, or revise the data if needed. 0.09 0.12 54.69 60.54 229
2 1 NA A30-062 - For MB/PT, Revenue Vehicle Inventory ID 353321, vehicle type changed from Bus last year to Cutaway this year. Please provide an explanation for this change or revise the data if needed. 0.09 0.12 54.81 60.63 230
2 1 NA A30-067 - RVI ID 392632 has been deleted from the MB/DO A-30 form. If the fleet is no longer in use as of the end of the Fiscal Year, the Active Vehicles number should be updated to zero (0) and the question “Is this vehicle retired?” should be marked as “Yes”. Please provide an explanation why this fleet was deleted. 0.09 0.12 54.93 60.72 231
2 1 NA A30-067 - RVI IDs 385309 and 385310 have been deleted from the DR/PT A-30 form. If the fleet is no longer in use as of the end of the Fiscal Year, the Active Vehicles number should be updated to zero (0) and the question “Is this vehicle retired?” should be marked as “Yes”. Please provide an explanation why these fleets were deleted. 0.09 0.12 55.06 60.82 232
2 1 NA A35-004 - The Useful Life Benchmark for Fleet ID 13585 (14) is different from last year’s Useful Life Benchmark (8). This is atypical as Useful Life Benchmark typically does not change. Please provide an explanation or revise the data if needed. 0.09 0.12 55.18 60.91 233
2 1 NA A35-013 - You have reported a steel wheel vehicle fleet on the A-35 form, but do not have any active rail modes on the P-20 form. Please provide an explanation or revise the data if needed. 0.09 0.12 55.31 61.00 234
2 1 NA A35-014 - You included RAV4 in the Agency Fleet Name for Fleet ID 17815, but reported the vehicle type as Automobile. Per FTA Policy, any vehicle larger than a station wagon should be classified as “Truck and Other Rubber Tire Vehicle”. The Agency Fleet name would suggest that this fleet should not be classified as Automobile. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.12 55.43 61.10 235
2 1 NA A35-014 - You included SUV in the Agency Fleet Name for Fleet ID 28312 and 28313, but reported the vehicle type as Automobile. Per FTA Policy, any vehicle larger than a station wagon should be classified as “Truck and Other Rubber Tire Vehicle”. The Agency Fleet name would suggest that this fleet should not be classified as Automobile. Please provide an explanation or revise the data if needed. 0.09 0.12 55.56 61.19 236
2 1 NA A35-014 - You included Van in the Agency Fleet Name for Fleet ID 17815, but reported the vehicle type as Automobile. Per FTA Policy, any vehicle larger than a station wagon should be classified as “Truck and Other Rubber Tire Vehicle”. The Agency Fleet name would suggest that this fleet should not be classified as Automobile. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.12 55.68 61.28 237
2 1 NA A35-014 - You included Van in the Agency Fleet Name for Fleet ID 28309 and 28314, but reported the vehicle type as Automobile. Per FTA Policy, any vehicle larger than a station wagon should be classified as “Truck and Other Rubber Tire Vehicle”. The Agency Fleet name would suggest that this fleet should not be classified as Automobile. Please provide an explanation or revise the data if needed. 0.09 0.12 55.80 61.37 238
2 1 NA A90-009 - You did not report a target for Trucks and other Rubber Tire Vehicles on the A-90 Form; however, you are reporting service vehicle fleets with the vehicle type on the A-35 Form. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.12 55.93 61.47 239
2 1 NA A90-010 - You did not report a target for Van on the A-90 Form; however, you are reporting revenue vehicle fleets with this vehicle type of the A-30 Form. Please provide an explanation or update the data on the associated form. 0.09 0.12 56.05 61.56 240
2 1 NA A90-010 - You reported a target for Van on the A-90 Form; however, you are not reporting revenue vehicles with this vehicle type on the A-30 Form. Please provide an explanation or revise the data if needed. 0.09 0.12 56.18 61.65 241
2 3 NA A90-011 - You did not report a target for Administrative / Maintenance Facilities on the A-90 Form; however, you are reporting facilities with this type on the A-15 Form for which your agency has capital responsibility. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or update the data on the associated form. 0.28 0.12 56.30 61.93 242
2 1 NA A90-011 - You did not report a target for Administrative / Maintenance Facilities on the A-90 Form; however, you are reporting facilities with this type on the A-15 Form for which your agency has capital responsibility. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or update the data on the associated form. 0.09 0.12 56.42 62.02 243
2 1 NA A90-011 - You did not report a target for Passenger / Parking Facilities or Administrative / Maintenance Facilities on the A-90 Form; however, you are reporting facilities with this type on the A-15 Form for which your agency has capital responsibility. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.12 56.55 62.12 244
2 1 NA A90-021 - You reported a performance target of 75.00% for Administrative / Maintenance Facilities. However, you reported 2 facilities of this type with condition assessments. Your performance target should be the number of facilities that you expect to be below condition 3 in fiscal year 2023, divided by the total number of facilities with condition assessments. The target of 75.00% does not appear consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 56.67 62.21 245
2 1 NA A90-022 - You reported a performance target of 1.00% for Rolling Stock: MV - Minivan. However, you reported 3 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. The target of 1.00% does not appear consistent with your current inventory. Please provide an explanation or revise the data if needed. 0.09 0.12 56.80 62.30 246
2 1 NA A90-022 - You reported a performance target of 1.00% for Rolling Stock: VN - Van. However, you reported 2 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. The target of 1.00% does not appear consistent with your current inventory. Please provide an explanation or revise the data if needed. 0.09 0.12 56.92 62.40 247
2 1 NA A90-022 - You reported a performance target of 10.00% for Rolling Stock: BR - Over-the-road Bus. However, you reported 9 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 10.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 57.05 62.49 248
2 1 NA A90-022 - You reported a performance target of 10.00% for Rolling Stock: BU - Bus. However, you reported 5 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 10.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 57.17 62.58 249
2 1 NA A90-022 - You reported a performance target of 10.00% for Rolling Stock: CU - Cutaway. However, you reported 8 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 10.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 57.29 62.67 250
2 1 NA A90-022 - You reported a performance target of 10.00% for Rolling Stock: MV - Minivan. However, you reported 3 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 10.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 57.42 62.77 251
2 1 NA A90-022 - You reported a performance target of 11.00% for Rolling Stock: CU - Cutaway. However, you reported 4 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 11.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 57.54 62.86 252
2 1 NA A90-022 - You reported a performance target of 14.00% for Rolling Stock: CU - Cutaway. However, you reported 10 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 14.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 57.67 62.95 253
2 1 NA A90-022 - You reported a performance target of 16.67% for Rolling Stock: CU - Cutaway. However, you reported 9 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 16.67% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 57.79 63.05 254
2 1 NA A90-022 - You reported a performance target of 17.00% for Rolling Stock: CU - Cutaway. However, you reported 10 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 17.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 57.91 63.14 255
2 1 NA A90-022 - You reported a performance target of 22.00% for Rolling Stock: CU - Cutaway. However, you reported 8 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. The target of 22.00% does not seem to be consistent with your current inventory. Please provide an explanation or revise the data if needed. 0.09 0.12 58.04 63.23 256
2 1 NA A90-022 - You reported a performance target of 25.00% for Rolling Stock: MV - Minivan. However, you reported 2 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. The target of 25.00% does not seem to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 58.16 63.32 257
2 1 NA A90-022 - You reported a performance target of 50.00% for Rolling Stock: BU - Bus and CU - Cutaway. However, you reported 3 revenue vehicles for each of these types, with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. The target of 50.00% does not seem to be consistent with your current inventory. Please provide an explanation or revise the data if needed. 0.09 0.12 58.29 63.42 258
2 1 NA A90-022 - You reported a performance target of 50.00% for Rolling Stock: CU - Cutaway. However, you reported 1 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 50.00% does not seem to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 58.41 63.51 259
2 1 NA A90-022 - You reported a performance target of 50.00% for Rolling Stock: CU - Cutaway. However, you reported 3 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 50.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 58.54 63.60 260
2 1 NA A90-022 - You reported a performance target of 50.00% for Rolling Stock: VN - Van. However, you reported 3 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 50.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 58.66 63.70 261
2 1 NA A90-022 - You reported a performance target of 66.00% for Rolling Stock: BU - Bus. However, you reported 2 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 66.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 58.78 63.79 262
2 1 NA A90-022 - You reported a performance target of 66.67% for Rolling Stock: MV - Minivan. However, you reported 1 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 66.67% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 58.91 63.88 263
2 1 NA A90-022 - You reported a performance target of 75.00% for Rolling Stock: CU - Cutaway. However, you reported 3 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 75.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 59.03 63.97 264
2 1 NA A90-022 - You reported a performance target of 87.50% for Rolling Stock: CU - Cutaway. However, you reported 7 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 87.50% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 59.16 64.07 265
2 1 NA A90-023 - You reported a performance target of 25.00% for Equipment: Trucks and other Rubber Tire Vehicles. However, you reported 1 service vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 25.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 59.28 64.16 266
2 1 NA A90-023 - You reported a performance target of 29.00% for Equipment: Automobiles. However, you reported 4 service vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 29.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 59.40 64.25 267
2 1 NA A90-023 - You reported a performance target of 50.00% for Equipment: Trucks and other Rubber Tire Vehicles. However, you reported 7 service vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. The target of 50.00% does not appear consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 59.53 64.35 268
2 1 NA A90-023 - You reported a performance target of 66.67% for Equipment: Trucks and other Rubber Tire Vehicles. However, you reported 2 service vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 66.67% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 59.65 64.44 269
2 1 NA A90-023 - You reported a performance target of 83.00% for Equipment: Automobiles. However, you reported 2 service vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2023, divided by the total number of vehicles with useful life benchmarks. So the target of 83.00% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report, or revise the data if needed. 0.09 0.12 59.78 64.53 270
2 1 NA Agency Fleet IDs 9097 and 9096 appear to share identical service characteristics. Please report these as one consolidated fleet, rather than reporting them as separate fleets. 0.09 0.12 59.90 64.62 271
2 1 NA

B10-027 - You selected “Independent Public Agency or Authority of Transit Service” as the Organization Type on this Urban/Tribal Subrecipient B-10 form; however, the urban agency selected “City, County or Local Government Unit or Department of Transportation” as the Organization Type on their B-10 form.

These selections should match. Please coordinate with this agency and either revise the data if needed, or advise if the urban agency will revise the data in their report.
0.09 0.12 60.02 64.72 272
2 1 NA Cares Act Rural Area Program Funds ($0) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds ($384,246) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 60.15 64.81 273
2 1 NA Cares Act Rural Area Program Funds ($2,645,738) from the subrecipient RR-20 Reduced Reporting Form does not equal the Urban form. The Urban form has the total amount of $2,645,738 split between CARES Act ($1,536,604) and CRRSA Act ($1,109,134). These values should match. Please explain or revise the data. 0.09 0.12 60.27 64.90 274
2 1 NA Cares Act Rural Area Program Funds ($384,276) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds ($384,246) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 60.40 65.00 275
2 1 NA Cares Act Rural Area Program Funds (§5311) ($0) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds (§5311) Funds Expended on Operations ($239,772) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 60.52 65.09 276
2 1 NA Cares Act Rural Area Program Funds (§5311) ($156,638) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds (§5311) Funds Expended on Operations ($0) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 60.65 65.18 277
2 1 NA Cares Act Rural Area Program Funds (§5311) ($488,232) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds (§5311) Funds Expended on Operations ($0) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 60.77 65.27 278
2 1 NA Cares Act Rural Area Program Funds (§5311) ($584,707) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds (§5311) Funds Expended on Operations ($200,431) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 60.89 65.37 279
2 1 NA Cares Act Rural Area Program Funds (§5311) ($591,789) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds (§5311) Funds Expended on Operations ($0) on the Urban form. The Urban reporter has placed this in the CARES Indian Reservations Program Funds (§5311). These values should match. Please explain or revise the data. 0.09 0.12 61.02 65.46 280
2 1 NA Cares Act Rural Area Program Funds (§5311) ($744,219) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds (§5311) Funds Expended on Operations ($744,249) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 61.14 65.55 281
2 1 NA Does your agency have a target for Administrative / Maintenance Facilities? Next year, RY21, agencies are required to have condition assessments on 100% of their facilities. Therefore, we would presume that there would be a 2021 target reported on the A-90. Please either revise or explain that there is not a target yet. 0.09 0.12 61.27 65.65 282
2 1 NA FTA ARRA Other than Urbanized Area Program funds (§5311) - capital assistance spent on operations, Funds Expended on Operations, is greater than zero ($218,210) in the current report year, but was zero last report year. It looks like this was placed under the wrong line item. Please explain or revise the data. 0.09 0.12 61.39 65.74 283
2 1 NA FTA Formula Grants for Rural Areas ($492,015) from the subrecipient RR-20 Reduced Reporting Form does not equal FTA Formula Grants for Rural Areas ($541,216) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 61.51 65.83 284
2 1 NA FTA Formula Grants for Rural Areas (186,060) from the subrecipient RR-20 Reduced Reporting Form does not equal FTA Formula Grants for Rural Areas (198,556) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 61.64 65.92 285
2 1 NA FTA Formula Grants for Rural Areas (§5311) ($0) from the subrecipient RR-20 Reduced Reporting Form does not equal FTA Formula Grants for Rural Areas (§5311) Funds Expended on Capital ($1,174,678) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 61.76 66.02 286
2 1 NA FTA Formula Grants for Rural Areas (§5311) ($453,763) from the subrecipient RR-20 Reduced Reporting Form does not equal FTA Formula Grants for Rural Areas (§5311) Funds Expended on Operations ($653,709) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 61.89 66.11 287
2 1 NA FTA Formula Grants for Rural Areas (§5311) ($503,506) from the subrecipient RR-20 Reduced Reporting Form does not equal FTA Formula Grants for Rural Areas (§5311) Funds Expended on Operations ($533,844) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.12 62.01 66.20 288
2 1 NA FTA Formula Grants for Rural Areas (§5311) Spent on Capital is $503,506 on the subrecipient RR-20, but the Urban agency has reported $92,865. These must match. Please revise or explain. 0.09 0.12 62.14 66.30 289
2 1 NA

Fleet 379617 in MB and Fleet 352568 in DR look to be the same exact vehicle as determined by having the same Agency Fleet ID of 155. In addition, the two vehicles have listed different ULB’s for the vehicle.

Please remove the incorrect ULB vehicle and re-add with the same RVI ID using the Add Existing Fleet button.

If these vehicles are actually not the same. Please revise the Agency Fleet ID and explain why two vehicles with the same type have different ULB’s.
0.09 0.12 62.26 66.39 290
2 1 NA

Fleet 379620 in MB and Fleet 352569 in DR look to be the same exact vehicle as determined by having the same Agency Fleet ID of 158. In addition, the two vehicles have listed different ULB’s for the vehicle.

Please remove the incorrect ULB vehicle and readd with the same RVI ID using the Add Existing Fleet button.

If these vehicles are actually not the same. Please revise the Agency Fleet ID and explain why two vehicles with the same type have different ULB’s.
0.09 0.12 62.38 66.48 291
2 1 NA Fleets 350255, 350258 and 360317 (Cutaways) are listed with the ULB of 5 years, yet the Sponsors Narrative Report stated that Cutaways in the plan have a ULB of seven years. Please either revise or explain. 0.09 0.12 62.51 66.57 292
2 1 NA Fleets 352602, 352603, 352604, 352605 (Buses) are listed with the ULB of 14 years, yet the Sponsors Narrative Report stated that Buses in the plan have a ULB of 12 years. Please either revise or explain. 0.09 0.12 62.63 66.67 293
2 1 NA Fleets 352606 and 352607 (Cutaways) are listed with the ULB of 10 years, yet the Sponsors Narrative Report stated that Cutaways in the plan have a ULB of seven years. Please either revise or explain. 0.09 0.12 62.76 66.76 294
2 1 NA For CB/DO, Revenue Vehicle Inventory ID (333670), vehicle type changed from Bus last year to Cutaway this year. Please confirm this is correct. 0.09 0.12 62.88 66.85 295
2 1 NA For DR/DO, Revenue Vehicle Inventory ID (353919), vehicle type changed from Van last year to Minivan this year. Please confirm this is correct. 0.09 0.12 63.00 66.95 296
2 1 NA For DR/DO, Revenue Vehicle Inventory ID 331450, vehicle type changed from Cutaway last year to Bus this year. Please confirm this change or revise the data if needed. 0.09 0.12 63.13 67.04 297
2 1 NA For DR/DO, the number of Total Vehicles for RVI ID 360041 equals zero. When retiring a vehicle, the active number changes to zero (0), but the Total Vehicle number should stay the same. Please re-enter the total number of vehicles to one. 0.09 0.12 63.25 67.13 298
2 1 NA For DR/PT, Revenue Vehicle Inventory ID (350294), vehicle type changed from Van last year to Minivan this year. Please confirm this is correct. 0.09 0.12 63.38 67.22 299
2 1 NA For DR/PT, Revenue Vehicle Inventory ID 341770 and 341771, vehicle type changed from Van last year to Minivan this year. Please confirm this change or revise the data if needed. 0.09 0.12 63.50 67.32 300
2 1 NA For DR/PT, the average Fare Revenue per UPT increased from $4.76 last year to $6.96 this year (+46%). Please explain this increase or revise. 0.09 0.12 63.63 67.41 301
2 1 NA For DR/PT, the number of Total Vehicles for RVI ID 352568 equals zero. When retiring a vehicle, the active number changes to zero (0), but the Total Vehicle number should stay the same. Please re-enter the total number of vehicles to one. 0.09 0.12 63.75 67.50 302
2 1 NA For DR/PT, the number of Total Vehicles for RVI IDs 341753 and 341754 equals zero. When retiring a vehicle, the active number changes to zero (0), but the Total Vehicle number should stay the same. Please re-enter the total number of vehicles for the RVIs that are being retired. 0.09 0.12 63.87 67.60 303
2 1 NA For Facility 17716 - Rio Vista Delta Breeze Yard, you reported a condition of 5 last year and 4 this year, but did not report that you performed a new condition assessment. Please enter the date of the new condition assessment, revise the condition assessment, or explain why the reported condition changed even though the facility was not re-assessed. 0.09 0.12 64.00 67.69 304
2 1 NA For Facility 3553 - Lassen Rural Bus Office & Maintenance Bay, you reported a condition of 4 last year and 3 this year, but did not report that you performed a new condition assessment. Please enter the date of the new condition assessment, revise the condition assessment, or explain why the reported condition changed even though the facility was not re-assessed. 0.09 0.12 64.12 67.78 305
2 1 NA For Facility 3554 - Bus Wash Facility, you reported a condition of 4 last year and 3 this year, but did not report that you performed a new condition assessment. Please enter the date of the new condition assessment, revise the condition assessment, or explain why the reported condition changed even though the facility was not re-assessed. 0.09 0.12 64.25 67.87 306
2 1 NA For MB/DO, Annual Vehicle Revenue Miles increased 18.0% compared to last year from (61,054) to (72,043). This change is outside the expected range, given the impact of the COVID-19 public health emergency on most transit systems. Please explain the change in Annual Vehicle Revenue Miles or revise the data. 0.09 0.12 64.37 67.97 307
2 1 NA For MB/DO, Revenue Vehicle Inventory ID (353931), vehicle type changed from Bus last year to Cutaway this year. Please confirm this is correct. 0.09 0.12 64.49 68.06 308
2 1 NA For MB/DO, the number of Total Vehicles for RVI IDs 316596, 316600, 316602 equals zero. When retiring a vehicle, the active number changes to zero (0), but the Total Vehicle number should stay the same. Please re-enter the total number of vehicles for the RVIs that are being retired. 0.09 0.12 64.62 68.15 309
2 1 NA For MB/PT, Annual Vehicle Revenue Miles increased 16.6% compared to last year from (479,359) to (559,079). This change is outside the expected range, given the impact of the COVID-19 public health emergency on most transit systems. Please explain the change in Annual Vehicle Revenue Miles or revise the data. 0.09 0.12 64.74 68.25 310
2 1 NA For MB/PT, Revenue Vehicle Inventory ID (381535), vehicle type changed from Bus last year to Cutaway this year. Please confirm this is correct. 0.09 0.12 64.87 68.34 311
2 1 NA For MB/PT, VOMS has historically been reported as 1, but increased to 5 in RY22. The agency’s validation responses indicate that the MB service is resuming pre-2021 service levels, but given that the VOMS have never been higher than 1, please confirm this year’s increase or revise the data if needed. 0.09 0.12 64.99 68.43 312
2 1 NA

For MB/PT, VOMS have historically been reported as the following:

2018: 8 2019: 7 2020: 7 2021: 7 2022: 14

Please explain why MB VOMS exceeded pre-pandemic service levels this year, or revise the data if needed.
0.09 0.12 65.11 68.52 313
2 1 NA For MB/PT, the number of Total Vehicles for RVI IDs 341753 and 341754 equals zero. When retiring a vehicle, the active number changes to zero (0), but the Total Vehicle number should stay the same. Please re-enter the total number of vehicles for the RVIs that are being retired. 0.09 0.12 65.24 68.62 314
2 1 NA For MB/PT, the number of Total Vehicles for RVI IDs 352570 and 379617 equals zero. When retiring a vehicle, the active number changes to zero (0), but the Total Vehicle number should stay the same. Please re-enter the total number of vehicles to one for both fleets. 0.09 0.12 65.36 68.71 315
2 1 NA For RVI ID 316577, you reported a Useful Life Benchmark of 8 this year, but reported 11 last year. Useful Life Benchmark does not typically change. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.12 65.49 68.80 316
2 1 NA For RVI ID 316601, you reported a Useful Life Benchmark of 15 this year, but reported 10 last year. Useful Life Benchmark does not typically change. Please revise Useful Life Benchmark, or explain why the value changed since last year. 0.09 0.12 65.61 68.90 317
2 1 NA For RVI ID 338160, 338161, and 353967, you reported a Useful Life Benchmark of 10 this year, but reported 5 last year. Useful Life Benchmark does not typically change. Please revise Useful Life Benchmark, or explain why the value changed since last year. 0.09 0.12 65.74 68.99 318
2 1 NA For RVI ID 338161, you reported a Useful Life Benchmark of 8 this year, but reported 4 last year. Useful Life Benchmark does not typically change. Please revise Useful Life Benchmark, or explain why the value changed since last year. 0.09 0.12 65.86 69.08 319
2 1 NA For RVI ID 341619, you reported a Useful Life Benchmark of 10 this year, but reported 14 last year. Useful Life Benchmark does not typically change. Please revise Useful Life Benchmark, or explain why the value changed since last year. 0.09 0.12 65.98 69.17 320
2 1 NA

In Report Year 2019, the agency was granted a waiver due to allocating Total Operating Expenses using Vehicle Revenue Miles.

The current average operating Cost per Mile (Operating Expenses divided by VRM) are identical across modes again, as such: CB/PT: $4.77 per hour DR/PT: $4.77 per hour MB/PT: $4.77 per hour

This indicates that you have allocated Operating Expenses based on Vehicle Revenue Miles. Please note that you must report direct costs to each mode prior to allocating the remaining indirect costs. Please revise the data or provide further explanation.
0.09 0.12 66.11 69.27 321
2 1 NA

In Report Year 2021, FTA issued the following note on the State’s closeout letter:

“On the Reduced Reporting RR-20 form for subrecipient 91078 - City of Escalon, the DR/PT mode, you stated that the values for Vehicle Revenue Miles (VRM), Vehicle Revenue Hours (VRH), and Unlinked Passenger Trips (UPT) appear unreliable. You stated in response to data validation that the contractor reported the DR/PT VRH based on drivers’ available hours, rather than true VRH. However, you could not address the specific reporting issues for the VRM and UPT other than confirming the data appear unreliable. You submitted a data waiver request for these data points; however, the request does not provide sufficient regarding the data reported for FTA to waive the requirement. Per your request, FTA is waiving DR/PT VRH and will mark the data with a “W” in the 2021 NTD publications. However, the values for VRM and UPT are considered questionable and will appear in the 2021 NTD publications with a “Q.””

Please confirm that the above issues have been resolved for Report Year 2022, and that the agency can attest to the accuracy of this year’s DR/PT VRM, VRH, and UPT, or provide more information if needed.
0.09 0.12 66.23 69.36 322
2 1 NA It was stated this facility is shared with an Airport, Private Bus Transit service. Please confirm or revise the A-15. 0.09 0.12 66.36 69.45 323
2 1 NA Last year it was reported that there were two maintenance facilities Leased by Public Agency for Service Provider between the DR and MB modes. This year there are two total maintenance facilities Owned By Service Provider between the DR and MB modes. Please explain or revise. 0.09 0.12 66.48 69.55 324
2 1 NA

Last year it was reported that you leased a maintenance facility from a private entity, but this year you are reporting one owned maintenance facility between the two A-10 forms. Please explain this change or revise.

If the agency does own a maintenance facility, it will also need to be added to the A-15 form.
0.09 0.12 66.60 69.64 325
2 1 NA Last year, you reported a total of 1 facility under “Leased by Service Provider” on the A-10 forms. This year, you reported 1 facility under “Leased by Public Agency for Service Provider.” Please provide an explanation for this change in ownership type, or revise the data if needed. 0.09 0.12 66.73 69.73 326
2 1 NA P20-002 - You added DR/DO service for RY 2022. Please provide a brief explanation for adding this mode and a brief description of the service. 0.09 0.12 66.85 69.82 327
2 1 NA

P20-002 - You added DR/PT service and provided an explanation in validation. In your explanation, you stated: “The City was able to segregate much, but not all, of the data by mode for RY 2022 but some data is still disaggregated.”

For validation purposes, please provide a brief description of how much data you were able to segregate by mode. For example, were you able to separate actual data for a certain number of months for the fiscal year (if so, how many months)? Additionally, for the data that you were not able to separate, is that data currently captured under the MB mode, or did you estimate the remaining data and report it under the DR mode?
0.09 0.12 66.98 69.92 328
2 2 NA Please describe the Other Directly Generated Funds reported. 0.19 0.12 67.10 70.10 329
2 1 NA Please describe the Other Directly Generated Funds. 0.09 0.12 67.23 70.19 330
2 1 NA Please describe the funds listed in the Describe Other Directly Generated Funds field. 0.09 0.12 67.35 70.29 331
2 1 NA Please describe the funds reported in Other Directly Generated Funds. 0.09 0.12 67.47 70.38 332
2 1 NA Please describe the type of funds listed in the Other Funds sections. 0.09 0.12 67.60 70.47 333
2 1 NA Please edit the agency name in the Profile. The I in City is currently an uppercase and should be lowercase. 0.09 0.12 67.72 70.57 334
2 1 NA Please explain the contract with the university that is reported in Other Directly Generated Funds. 0.09 0.12 67.85 70.66 335
2 1 NA

Please explain the large increases in the organization paid fares for both modes this year.

Demand Response: $1,350 to $33,465 (+2,379%) Bus: $1,650 to $16,235 (+884%)
0.09 0.12 67.97 70.75 336
2 1 NA Please move the items from Other Funds to Other Directly Generated Funds. 0.09 0.12 68.09 70.84 337
2 1 NA Please provide a description for the funds listed in Other Directly Generated Funds. 0.09 0.12 68.22 70.94 338
2 1 NA Please provide a description for the funds reported in Other Directly Generated Funds. 0.09 0.12 68.34 71.03 339
2 1 NA Please report MB as the secondary mode if this facility services MB as well. s 0.09 0.12 68.47 71.12 340
2 1 NA Please report a target or select N/A for the “OR - Other” revenue vehicle type in section 1. The Narrative Report indicates that this should reflect N/A. 0.09 0.12 68.59 71.22 341
2 1 NA Please report the A-90 information or select your TAM Plan Sponsor. 0.09 0.12 68.72 71.31 342
2 1 NA Please report the updated zip code to the facility. 0.09 0.12 68.84 71.40 343
2 1 NA Please select N/A for Steel Wheel Vehicles. 0.09 0.12 68.96 71.49 344
2 1 NA Please select N/A for the Automobile line in section two since we will not have any of these vehicles after revising the A-35 form. 0.09 0.12 69.09 71.59 345
2 5 NA Please select N/A for the asset classes the agency does not have. 0.46 0.12 69.21 72.05 346
2 1 NA Please select N/A for the assets the agency does not have, 0.09 0.12 69.34 72.14 347
2 6 NA Please select N/A for the assets the agency does not have. 0.56 0.12 69.46 72.70 348
2 1 NA Please select NA for the asset classes the agency does not have. 0.09 0.12 69.58 72.79 349
2 7 NA Please select NA for the assets the agency does not have. 0.65 0.12 69.71 73.44 350
2 1 NA Please select NA for the assets your agency does not have. 0.09 0.12 69.83 73.54 351
2 1 NA RR20F-182 - The sum of Funds Expended on Capital for all modes on the RR-20 form equals $0, but the sum of total vehicles for all modes (3) is greater than last year (1). Please provide an explanation for why this agency reported new vehicles without any capital expenses, or update the data on the associated form. 0.09 0.12 69.96 73.63 352
2 1 NA RR20F-228 - You reported 1 reportable event; however, you did not report any Injuries or Fatalities. A Reportable Event as defined by NTD includes, but is not limited to: property damage equal to or exceeding $25,000, collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle, and an evacuation for life safety reasons. Please confirm that this incident met one of the reporting criteria, or revise the data if needed. 0.09 0.12 70.08 73.72 353
2 1 NA RR20F-228 - You reported 1 reportable event; however, you did not report any Injuries or Fatalities. A Reportable Event as defined by NTD includes, but is not limited to: property damage equal to or exceeding $25,000, collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle, and an evacuation for life safety reasons. Please confirm that this reportable event met one of these criteria, or revise the data if needed. 0.09 0.12 70.20 73.82 354
2 1 NA RR20F-228 - You reported 1 reportable event; however, you did not report any Injuries or Fatalities. A Reportable Event as defined by NTD includes, but is not limited to: property damage equal to or exceeding $25,000, collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle, and an evacuation for life safety reasons. Please confirm that this safety event met one of the thresholds, or revise the data if needed. 0.09 0.12 70.33 73.91 355
2 1 NA RR20F-228 - You reported 2 reportable events; however, you did not report any Injuries or Fatalities. A Reportable Event as defined by NTD includes, but is not limited to: property damage equal to or exceeding $25,000, collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle, and an evacuation for life safety reasons. Please confirm that these incidents met one of the reporting criteria, or revise the data if needed. 0.09 0.12 70.45 74.00 356
2 1 NA RR20F-230 - For DR/PT, you reported $194,824 in Operating Expenses. This reflects a 63.7% increase From last year’s Operating Expenses for DR/PT, $119,005, and exceeds the values reported during pre-pandemic services. Please provide an explanation for the increase in DR expenses, or revise the data if needed. 0.09 0.12 70.58 74.09 357
2 1 NA RR20F-232 - You reported $493,626 Revenues Accrued through a Purchased Transportation Agreement with an NTD reporting agency, Funds Expended on Operations this report year; however, you did not report these funds last report year. This is a rare selection for rural transit agencies as it indicates you are the seller of transportation service in a full-cost PT contract. Please provide an explanation or revise the data if needed. 0.09 0.12 70.70 74.19 358
2 1 NA RR20F-237 - For MB/PT, you reported $0 under Organization-Paid Fares, Funds Expended on Operations, last report year. However, you reported $14,748 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed. 0.09 0.12 70.83 74.28 359
2 1 NA RR20F-237 - You reported $0 under Organization-Paid Fares, Funds Expended on Operations, last report year. However, you reported $1,040 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed. 0.09 0.12 70.95 74.37 360
2 1 NA RR20F-237 - You reported $0 under Organization-Paid Fares, Funds Expended on Operations, last report year. However, you reported $11,250 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed. 0.09 0.12 71.07 74.47 361
2 1 NA RR20F-237 - You reported $1,790 under Organization-Paid Fares, Funds Expended on Operations, last Report Year. However, you reported $0 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed. 0.09 0.12 71.20 74.56 362
2 1 NA Rev Accrued through PT agreement-NTD, Funds Expended on Operations (302,135) is populated in the current years report but was zero or null in last years report. 0.09 0.12 71.32 74.65 363
2 1 NA Rev Accrued through PT agreement-Non NTD, Funds Expended on Operations is zero or null in the current year report but was populated (272,202) in last years report. 0.09 0.12 71.45 74.74 364
2 1 NA Service Truck 13320 has a ULB of 20 years which differs from the other Service Truck 13319 ULB of 12 on the A-35 form. Please confirm this ULB is correct and differs or revise. 0.09 0.12 71.57 74.84 365
2 1 NA The DR/DO Vehicle Revenue Miles (151,434) for this agency changed 15.7% since last year (130,882). Was this service impacted by the pandemic at all? Please revise the data or explain. 0.09 0.12 71.69 74.93 366
2 1 NA The DR/PT Fare Revenue per Passenger this year ($0.62) decreased 38% from last year ($1.01). This was caused by the passengers decreasing 23%, but the fares decreased 53%. Please explain this fluctuation or revise. 0.09 0.12 71.82 75.02 367
2 1 NA The Demand Response Fare per Passenger this year ($3.01) increased 66% since last year ($1.82). This was caused by the UPT decreasing 32% (20,329 to 13,927) and the Fares increasing 14% ($36,955 to $41,979). Please explain this fluctuation or revise. 0.09 0.12 71.94 75.12 368
2 1 NA The Demand Response Unlinked Passenger Trips this year (11,461) decreased 35% since last year (17,517) but the Vehicle Revenue Hours increased 1.15% from last year (2,349 to 2,376). Please explain this fluctuation or revise. 0.09 0.12 72.07 75.21 369
2 1 NA The Fare Revenue per UPT this year of $0.64 decreased 71% since last years amount of $2.23, This was caused by the passengers decreasing 54%, but the fare revenues decreasing 87% with no passenger paid fares reported. Please explain this fluctuation further. 0.09 0.12 72.19 75.30 370
2 1 NA The Fare Revenues are allocated by exact percentages between the Demand Response mode (11%) and the Bus mode (89%). In addition, the passenger paid and organization paid fares are also allocated by the same percentages. Agencies are required to report actual fares per mode. Please revise. 0.09 0.12 72.32 75.39 371
2 1 NA The Fare Revenues per Unlinked Passenger Trip is the same for both modes at $2.17. This indicates that the modal fare revenues are allocated based on the same split of the modal unlinked passenger trips. Agencies should report actual fares per mode. Please revise. 0.09 0.12 72.44 75.49 372
2 1 NA The Fare Revenues per mode are allocated at exactly 20% for Demand Response and 80% for Bus. Please report actual fares per mode. 0.09 0.12 72.56 75.58 373
2 1 NA The Fare Revenues per mode are allocated based on exact percentages of 12% for Demand Response and 88% for Bus. Agencies are required to report actual fares per mode. Please revise. 0.09 0.12 72.69 75.67 374
2 1 NA The Fare Revenues this year ($35,582) decreased 66% from last year ($105,664), but the passengers only decreased 11%. Please explain this fluctuation or revise. 0.09 0.12 72.81 75.77 375
2 1 NA The MB/DO Fare Revenue per UPT this year ($2.40) increased 58% since last year ($1.52). This was caused by the ridership decreasing 29%, but the fare revenues increasing 13%. Please explain this fluctuation or revise. 0.09 0.12 72.94 75.86 376
2 1 NA The MB/DO Vehicle Revenue Miles (304,724) for this agency changed 0.5% since last year (303,195). Was this service not impacted by the pandemic? Please revise the data or explain. 0.09 0.12 73.06 75.95 377
2 1 NA The MB/PT VOMS this year (47) increased significantly since last year (17). Please provide factors that caused this large increase or revise the data. 0.09 0.12 73.18 76.04 378
2 1 NA The MB/PT Vehicle Revenue Miles (349,688) for this agency changed 1.5% since last year (344,638). Was this service not impacted by the pandemic? Please revise the data or explain. 0.09 0.12 73.31 76.14 379
2 1 NA The MB/PT Vehicle Revenue Miles (393,512) for this agency changed 10.1% since last year (357,536). Was this service not impacted by the pandemic? Please revise the data or explain. 0.09 0.12 73.43 76.23 380
2 1 NA The MB/PT Vehicle Revenue Miles (52,097) for this agency changed 0.4% since last year (51,914). Was this service not impacted by the pandemic? Please revise the data or explain. 0.09 0.12 73.56 76.32 381
2 1 NA The MB/PT Vehicle Revenue Miles (947,350) for this agency changed 0.7% since last year (940,798). Was this service not impacted by the pandemic? Please revise the data or explain. 0.09 0.12 73.68 76.42 382
2 1 NA

The Operating Expenses and Vehicle Revenue Miles per mode reflect the following average operating cost per mile values:

2020 DR/DO: $5.17 per mile 2020 MB/DO: $5.18 per mile

This has also been the case for the previous three Report Years:

2019 DR/DO: $4.54 per mile 2019 MB/DO: $4.57 per mile

2018 DR/DO: $4.61 per mile 2018 MB/DO: $4.61 per mile

2017 DR/DO: $5.00 per mile 2017 MB/DO: $5.00 per mile

The agency received a waiver last year for allocating operating expenses and the trend indicates that this agency allocated Operating Expenses based on VRM again this year. Please clarify how this agency reported its Operating Expenses by mode or revise.
0.09 0.12 73.81 76.51 383
2 1 NA

The Operating Expenses for the DR and MB modes have changed in the following ways:

DR increased from $170,993 last year to $980,081 this year (473.17%) MB decreased from $1,077,241 last year to $208,246 this year (-80.67%)

Because the service data for these modes have not significantly changed from last year, the DR average cost per hour increased from $75 to $328 this year, while the MB average cost per hour decreased from $145 last year to $29 this year. These changes are atypical.

Please confirm that the Operating Expense values for these modes were not transposed on the RR-20 form. If the values are correct as reported, please explain the significant changes for both modes.
0.09 0.12 73.93 76.60 384
2 1 NA The Primary Mode for the Maintenance Facility is MB, but the CB mode has the majority allocation between the A-10 forms. Please revise to show CB as the Primary Mode/MB as a Secondary Mode OR revise the A-10 allocations to show a majority to MB. 0.09 0.12 74.05 76.69 385
2 1 NA The URL on the profile does not provide a valid website. Please revise. 0.09 0.12 74.18 76.79 386
2 1 NA The Vehicle Revenue Miles (202,942) for this agency changed 0.3% since last year (202,275). Was this agency not impacted by the pandemic? Please revise the data or explain. 0.09 0.12 74.30 76.88 387
2 1 NA The Vehicle Revenue Miles (479,359) for this agency changed 8.3% since last year (442,720). Was this agency impacted by the pandemic? Please revise the data or explain. 0.09 0.12 74.43 76.97 388
2 1 NA The average Fare Revenue per UPT this year of $1.08 increased 71% since last year of $0.63. Please explain this increase or revise. 0.09 0.12 74.55 77.07 389
2 1 NA The average fare per passenger increased from $5.07 last year to $6.47 this year. This was caused by the passengers decreasing 4.4% and the fares increasing 22%. Please provide factors that caused this fluctuation. 0.09 0.12 74.67 77.16 390
2 1 NA The average motor bus fare per rider this year ($1.18) increased 73% since last year ($0.68). This was caused by the passengers decreasing 22% (1,,054,667 to 825,820) but the fares increasing 36% ($714,868 to $970,968). This fluctuation is large and unusual. Please explain the factors that caused the amount of motor bus fares to largely increase while the passengers decreased or revise the data. 0.09 0.12 74.80 77.25 391
2 1 NA The calculated cost per mile for DR/PT equals ($6.96) for the current report year and equals ($4.26) in the previous report year. That is a (63.38%) change, which is high. Cost per mile is the operating expenses by mode divided by VRM on the RR-20. Please explain or revise the data. 0.09 0.12 74.92 77.34 392
2 1 NA The calculated cost per mile for MB/DO equals ($10.82) for the current report year and equals ($5.53) in the previous report year. That is a (95.66%) change, which is high. Cost per mile is the operating expenses by mode divided by VRM on the RR-20. Please explain or revise the data. 0.09 0.12 75.05 77.44 393
2 1 NA The calculated cost per mile for MB/PT equals ($4.29) for the current report year and equals ($2.84) in the previous report year. That is a (51.06%) change, which is high. Cost per mile is the operating expenses by mode divided by VRM on the RR-20. Please explain or revise the data. 0.09 0.12 75.17 77.53 394
2 1 NA The capital expenses per mode are allocated by the same percentage as the operating expenses per mode. Please report the actual capital expenses per mode. 0.09 0.12 75.29 77.62 395
2 1 NA

The narrative report does not contain a narrative describing the targets or the progress towards the targets.

In addition, please select N/A for the assets that the agency does not have.
0.09 0.12 75.42 77.72 396
2 1 NA The narrative report says your agency set a 16% target for Cutaway, but the A-90 shows your target of 0%. Please either revise or explain. 0.09 0.12 75.54 77.81 397
2 1 NA The narrative report states that the Corcoran ULB is 20 years per vehicle, but not all ULB’s are listed as 20. Please explain or revise. 0.09 0.12 75.67 77.90 398
2 1 NA The narrative report states you have Trucks, but no service vehicles are listed on the A-35 form. Please explain or revise. 0.09 0.12 75.79 77.99 399
2 1 NA The narrative report uploaded does not contain any sort of narrative regarding the agency assets or progress towards their targets. Please revise. 0.09 0.12 75.92 78.09 400
2 1 NA The number of Total Vehicles for RVI ID 350301 equals zero. When retiring a vehicle, the active number changes to zero (0), but the Total Vehicle number should stay the same. Please re-enter the total number of vehicles to one. 0.09 0.12 76.04 78.18 401
2 1 NA The number of injuries per incident (4.00) is unusually high. Please confirm that all injuries required immediate medical attention away from the scene or revise. 0.09 0.12 76.16 78.27 402
2 1 NA The operating expenses for both modes increased by the same percentage of 5.22%. This indicates that you allocated your total operating expenses by the same percentage split as the prior year. Please revise to report actual expenses per mode. 0.09 0.12 76.29 78.37 403
2 1 NA The total operating expenses are allocated by exact percentages for each mode. Demand Response is exactly 79% of the total and Bus is exactly 21% of the total. Agencies are to report actual expenses per mode. Please revise. 0.09 0.12 76.41 78.46 404
2 1 NA The website on the profile does not provide a valid link. Please revise. 0.09 0.12 76.54 78.55 405
2 1 NA There was a large increase in operating expenses this year from $300k last year to $1,694,088 this year. Please confirm the amount of CARES Act funding of $1,394,088 was expended during FY21 0.09 0.12 76.66 78.64 406
2 1 NA

This agency reported $1,277,349 under CARES Act Rural Area Program Funds (§5311) in their direct urban report.

You reported $1,277,350 under CRRSA Act Rural Area Program Funds (§5311) in this urban subrecipient report.

Please coordinate with this agency to determine the correct funding program, and revise the data if needed.
0.09 0.12 76.78 78.74 407
2 1 NA

This agency reported $1,303,121 under FTA Formula Grants for Rural Areas (§5311) in their direct urban report.

This agency’s subrecipient report reflects $463,087 under FTA Formula Grants for Rural Areas (§5311), and $840,034 under CARES Act Rural Area Program Funds (§5311) - the total comes to $1,303,121.

Please coordinate with this agency to determine the correct funding source breakdown, or revise the data if needed.
0.09 0.12 76.91 78.83 408
2 1 NA This year you are reporting one maintenance facility as Leased from Another Public Agency, but last year you reported the maintenance facility as Owned. Please explain or revise. 0.09 0.12 77.03 78.92 409
2 1 NA Vehicle Revenue Miles (51,711) for this agency changed 3.4% since last year (50,028). Was this agency not impacted by the pandemic? Please revise the data or explain. 0.09 0.12 77.16 79.02 410
2 1 NA Vehicle Revenue Miles (61,054) for this agency changed 2.6% since last year (59,499). Was this agency’s service not impacted by the pandemic? Please revise the data or explain. 0.09 0.12 77.28 79.11 411
2 1 NA You added a new fleet to the CB A-30 form (391632), but did not report any capital expenses to the CB mode on the RR-20 form. Please explain or revise. 0.09 0.12 77.41 79.20 412
2 1 NA You added a new fleet to the CB A-30 form this year (392644), but did not report any capital expenses to the CB mode on the RR-20 form. Please explain or revise. 0.09 0.12 77.53 79.29 413
2 1 NA You added one vehicle to the MB A-30 and one vehicle to the A-35 form that only services the MB mode, but no capital expenses were reported to the MB mode on the RR-20. Please explain or revise. 0.09 0.12 77.65 79.39 414
2 1 NA You added the following facilities to your A-15 form this year: 18787 - Transit Facility. Please explain why these facilities were added this year. 0.09 0.12 77.78 79.48 415
2 1 NA You added the following facilities to your A-15 form this year: 19295 - Transit Operations & Maintenance Facility. Please explain why this facility was added this year. 0.09 0.12 77.90 79.57 416
2 1 NA You added the following facilities to your A-15 form this year: 19299 - Bishop Bus Yard. Please explain why these facilities were added this year. 0.09 0.12 78.03 79.67 417
2 1 NA You added three new fleets to the DR A-30 form (391633, 391634, 391635) but did not report any capital expenses to the DR mode. Please explain or revise. 0.09 0.12 78.15 79.76 418
2 1 NA You allocated the capital expenses per mode based on the Vehicle Revenue Hours per mode. Please report actual capital expenses per mode. If there is a capital item for both modes, please report the capital expense to only one mode. 0.09 0.12 78.27 79.85 419
2 1 NA You are listing one maintenance facility that is Owned by the Service Provider, but you are listing the maintenance facility on the A-15 with 100% capital responsibility. This is unusual. If the City of Dinuba owns the facility/has 100% capital responsibility, we would expect the maintenance facility to be listed as Owned by Public Agency for the Service Provider. Please either explain or revise. 0.09 0.12 78.40 79.94 420
2 2 NA You are missing a fiscal year end date on your B-10 form. Please add the fiscal year end date to your B-10 form. 0.19 0.12 78.52 80.13 421
2 1 NA You are reporting $162,445 of CRRSA Act Rural Area Program Funds (§5311) but the urban agency is reporting this amount to CARES Act Rural Area Program Funds (§5311). Please either revise to match the correct funding source or discuss with the urban agency to revise. 0.09 0.12 78.65 80.22 422
2 1 NA You are reporting Organization Paid Fare Revenues for the first time this year. Please explain this figure further. What changed from the prior year? 0.09 0.12 78.77 80.32 423
2 1 NA You changed ID 17817 and 17818 from Truck to Automobile this year but the Fleet Name states that these are Transit Connect vans. Per FTA Policy, any vehicle larger than a station wagon should be classified as “Truck and Other Rubber Tire Vehicle”. The Agency Fleet name would suggest that this fleet should not be classified as Automobile. Please explain or revise. 0.09 0.12 78.90 80.41 424
2 1 NA You changed all the ULB’s to 9 this year when the Cutaways were 10 last year and the Buses were 14 last year. Useful Life Benchmark does not typically change. Please revise Useful Life Benchmark, or explain why the value changed since last year. 0.09 0.12 79.02 80.50 425
2 1 NA

You changed the Manufacture Year of the service vehicle from 2016 last year to 2017 this year. Please explain this change or revise.

In addition, you have the Year Dollars of Estimated Cost as 2016, but this vehicle was not even manufactured until 2017. Please explain this change or revise as well.
0.09 0.12 79.14 80.59 426
2 1 NA You changed the Vehicle Type from Truck to Automobile for Fleet ID’s 17899, 23034, and 23035. These are listed as a Durango and Explorers. Per FTA Policy, any vehicle larger than a station wagon should be classified as “Truck and Other Rubber Tire Vehicle”. The Agency Fleet names would suggest that these should not be classified as Automobile. Please explain or revise. 0.09 0.12 79.27 80.69 427
2 5 NA You did not report a target for Administrative / Maintenance Facilities on the A-90 Form; however, you are reporting facilities with this type on the A-15 Form for which your agency has capital responsibility. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or revise the data. 0.46 0.12 79.39 81.15 428
2 2 NA You did not report a target for Automobile on the A-90 Form; however, you are reporting revenue vehicle fleets with this vehicle type of the A-30 Form. Please provide an explanation or revise the data. 0.19 0.12 79.52 81.34 429
2 1 NA You did not report a target for Automobiles on the A-90 Form; however, you are reporting service vehicle fleets with the vehicle type on the A-35 Form. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or revise the data. 0.09 0.12 79.64 81.43 430
2 1 NA You did not report a target for Bus on the A-90 Form; however, you are reporting revenue vehicle fleets with this vehicle type of the A-30 Form. Please provide an explanation or revise the data. 0.09 0.12 79.76 81.52 431
2 1 NA You did not report a target for Minivan on the A-90 Form; however, you are reporting revenue vehicle fleets with this vehicle type of the A-30 Form. Please provide an explanation or revise the data. 0.09 0.12 79.89 81.62 432
2 1 NA You did not report a target for Passenger / Parking Facilities on the A-90 Form; however, you are reporting facilities with this type on the A-15 Form for which your agency has capital responsibility. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or revise the data. 0.09 0.12 80.01 81.71 433
2 2 NA You did not report a target for Trucks and other Rubber Tire Vehicles on the A-90 Form; however, you are reporting service vehicle fleets with the vehicle type on the A-35 Form. For all assets for which your agency has capital responsibility, you are required to report targets on the A-90 form. Please provide an explanation or revise the data. 0.19 0.12 80.14 81.89 434
2 1 NA You did not report a target for Van on the A-90 Form; however, you are reporting revenue vehicle fleets with this vehicle type of the A-30 Form. Please provide an explanation or revise the data. 0.09 0.12 80.26 81.99 435
2 1 NA You did not report a vehicle length for the following RVI ID(s) (387644, 387643, 387642, 387641, 387640, 387639, 387638) on the A-30 Revenue Vehicle Inventory Form. Please add the vehicle length under the vehicle information section on the A-30 Revenue Vehicle Inventory Form or explain why the data is correct as reported. Please revise the data or explain. 0.09 0.12 80.38 82.08 436
2 1 NA You did not report any Funds Expended on Capital; however, you reported new vehicles on the Service Vehicle Inventory (A-35) Form. Usually, new vehicles are received in the same year the liability is incurred. 0.09 0.12 80.51 82.17 437
2 1 NA You did not report any demand response organization paid fares this year. Please explain or revise. 0.09 0.12 80.63 82.27 438
2 1 NA You did not report any organization paid fares this year. Please explain this change or revise. 0.09 0.12 80.76 82.36 439
2 1 NA You have a reported 0% Transit Agency Capital Responsibility for 9746 which has a facility type of Administrative Office / Sales Office. Administrative and maintenance facilities are only reportable if your agency has some level of capital responsibility for the facility. In the prior submission, you reported this with 100% and a Condition Assessment of 4. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.12 80.88 82.45 440
2 1 NA You have newly selected “Section of a Larger Facility” for Facility ID(s) 18788, however, you have not inventoried any other facilities with the same address or latitude and longitude. Please note that “Section of a Larger Facility” should only be selected if you are inventorying multiple sections of the same facility. It should not represent facilities that are shared-use. Please provide an explanation or update the data on the associated form. 0.09 0.12 81.01 82.54 441
2 2 NA You have not uploaded the narrative report to the A-90 form. This is required for report year 2020. The narrative report outlines performance targets and your progress towards the targets. This narrative may include any changes in transit system conditions that may affect progress towards targets. A template for the Narrative Report can be found here: https://www.transit.dot.gov/TAM/Resources/Tools/NTDNarr Please revise. 0.19 0.12 81.13 82.73 442
2 2 NA You have not uploaded the narrative report to the A-90 form. This is required for report year 2021. The narrative report outlines performance targets and your progress towards the targets. This narrative may include any changes in transit system conditions that may affect progress towards targets. A template for the Narrative Report can be found here: https://www.transit.dot.gov/regulations-and-programs/asset-management/NTD-narrative-report-example-format Please revise. 0.19 0.12 81.25 82.92 443
2 1 NA You have reported $400,000 to the CRRSA Act Funds line item, but the Urban report has the same amount reported to the CARES Act Funds line item. Please revise or explain as these must match. 0.09 0.12 81.38 83.01 444
2 1 NA You have reported 1 Reportable Incident and 1 Injury. Please confirm the injured person had to be transported from the scene to seek immediate medical attention, or revise the data if needed. 0.09 0.12 81.50 83.10 445
2 1 NA You have reported 1 Reportable Incident with 1 Injury. Please confirm the injured person required immediate medical attention away from the scene of the incident, or revise the data if needed. 0.09 0.12 81.63 83.19 446
2 1 NA You have reported 1 square feet for facility ID 17672. Please revise. 0.09 0.12 81.75 83.29 447
2 1 NA

You have reported 12 Reportable Incidents, and 3 Injuries. For the incidents that resulted in injuries, please confirm that the injured persons required immediate medical attention away from the scene, or revise the data if needed. For all other incidents, please confirm that each incident met one of the NTD reporting thresholds, or revise the data if needed. The thresholds are:

• A fatality (including suicide) confirmed within 30 days of the event • An injury requiring immediate medical attention away from the scene for one or more persons • Property damage equal to or exceeding $25,000 • Collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle • An evacuation of a transit facility or vehicle for life safety reasons.
0.09 0.12 81.87 83.38 448
2 1 NA You have reported 12/31/2022 as the Fiscal Year End Date. In previous years, you reported 6/30. The Fiscal Year End Date should represent the 12-month period for which you are reporting data in this report. Please provide an explanation for this change, or revise the data if needed. 0.09 0.12 82.00 83.47 449
2 1 NA You have reported 738,717 under CRRSA Act Public Transportation on Indian Reservations Program Funds (§5311). Please confirm these should not be reported under CRRSA Act Rural Area Program Funds (§5311), or revise the data if needed. 0.09 0.12 82.12 83.57 450
2 1 NA You have reported Other Directly Generated Funds with the description “Ask the agency.” Please provide a description of these funds in the form. 0.09 0.12 82.25 83.66 451
2 1 NA You have reported Other Directly Generated Funds with the description “Route Guarantee explanation.” Please explain the source of these funds in the form, or revise the data if needed. 0.09 0.12 82.37 83.75 452
2 1 NA You have reported Other Funds with the description “Advertising, Contract revenues.” Please report these under Other Directly Generated Funds. 0.09 0.12 82.50 83.84 453
2 1 NA You have reported Other Funds with the description “State of Good Repair.” If these funds originated from FTA, please report them under “+ FTA State of Good Repair Program (§5337).” 0.09 0.12 82.62 83.94 454
2 1 NA You have reported Other Funds with the description “TDA (Transportation Development Act).” These funds appear to originate from a State program. If this is correct, please report them under State Funds. 0.09 0.12 82.74 84.03 455
2 1 NA You have reported Other Funds with the following description: “(5337) State of Good Repairs.” Please report these funds in the Federal Funds section, under the field Other FTA Funds. 0.09 0.12 82.87 84.12 456
2 1 NA You have reported Other Funds with the following description: “funds by NPS-DOI; These funds are all from the National Part Service funds provided for operations.” If these funds originated from the National Park Service, please report them under Other Federal Funds. 0.09 0.12 82.99 84.22 457
2 1 NA You have reported Percent Agency Capital Responsibility 1.00% for Facility ID 19299, Bishop Bus Yard as less than 100%, which indicates the capital responsibility is shared. Please complete the Notes section to describe this shared capital responsibility relationship. 0.09 0.12 83.12 84.31 458
2 1 NA You have reported Percent Agency Capital Responsibility 50.00% for Facility ID 19295, Transit Operations & Maintenance Facility as less than 100%, which indicates the capital responsibility is shared. Please complete the Notes section to describe this shared capital responsibility relationship. 0.09 0.12 83.24 84.40 459
2 1 NA You have reported RTAP funds under Other Funds. Please report these under the 5311 program field in the Federal Funds section. 0.09 0.12 83.36 84.49 460
2 1 NA You have reported a general fund contribution under Other Directly Generated Funds. If these funds originated from the City of Auburn’s general fund, please move these to Local Funds. 0.09 0.12 83.49 84.59 461
2 1 NA You have reported contract revenue under Other Funds. Please move these to Other Directly Generated Funds. 0.09 0.12 83.61 84.68 462
2 1 NA You have reported interest income under Other Funds. Please move these to Other Directly Generated Funds. 0.09 0.12 83.74 84.77 463
2 1 NA

You have reported the following 5311 funds in this urban subrecipient report: FTA Formula Grants for Rural Areas (§5311): $1,065,737 CRRSA Act Rural Area Program Funds (§5311): $37,674

This agency reported the following 5311 funds in their direct urban report: FTA Formula Grants for Rural Areas (§5311): $1,065,737 CRRSA Act Rural Area Program Funds (§5311): $0

Please coordinate with this agency to determine the correct reporting setup, and either revise the data or advise if the urban agency will revise their report.
0.09 0.12 83.86 84.87 464
2 1 NA

You have reported the following 5311 values on the Urban Subrecipient RR-20 form: FTA Formula Grants for Rural Areas (§5311) - $630,653 CARES Act Rural Area Program Funds (§5311) - $602,012

The urban agency has reported the following values on their S-10 form: FTA Formula Grants for Rural Areas (§5311) - $769,578

Because the State and urban agency are reporting on the same 12-month fiscal year period, these values should match. Please coordinate with the agency to determine the correct amounts, and revise the data in this report if needed.
0.09 0.12 83.99 84.96 465
2 1 NA

You have reported two incidents on the RR-20 form. Please confirm these meet at least one threshold or revise.

• Property damage equal to or exceeding $25,000 • Collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle • An evacuation of a transit facility or vehicle for life safety reasons
0.09 0.12 84.11 85.05 466
2 1 NA You included Van in the Agency Fleet Name for Fleet ID 17815, but reported the vehicle type as Automobile. Per FTA Policy, any vehicle larger than a station wagon should be classified as “Truck and Other Rubber Tire Vehicle”. The Agency Fleet name would suggest that this fleet should not be classified as Automobile. Please explain or revise. 0.09 0.12 84.23 85.14 467
2 1 NA You inserted a Bus target on the A-90, but do not have any Buses in the inventory. Please move to the Cutaway line and then select N/A for the Bus line item. 0.09 0.12 84.36 85.24 468
2 1 NA You inserted a target for Minivan of 0%, but the performance for Minivan is 100%. This indicates that you believe that Minivans will come into a State of Good Repair by 2021. Please confirm this is what you intended to report or revise. 0.09 0.12 84.48 85.33 469
2 1 NA You listed Service Fleet 187527 with 0 active vehicles, but did not retire it. Please explain further or revise. 0.09 0.12 84.61 85.42 470
2 1 NA You listed a Private Mode for the facility of Airport Private Bus Transit. Please confirm or revise. 0.09 0.12 84.73 85.52 471
2 1 NA You listed fleets (341765 and 341769) with 0 active vehicles but did not answer if the fleets were retired. Please select Yes if the fleets are retired or No if the fleets are inactive. Inactive vehicles are either in storage, retained for emergency contingency purposes, out of service for an extended period of time for major repairs or awaiting sale or disposal 0.09 0.12 84.85 85.61 472
2 1 NA You removed the following facilities from your A-15 form this year: 9746 - Mammoth Operations Facility. Please explain why this facility was removed this year. 0.09 0.12 84.98 85.70 473
2 1 NA You reported $0 under Organization-Paid Fares, Funds Expended on Operations, last report year. However, you reported $4,590 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed. 0.09 0.12 85.10 85.79 474
2 1 NA You reported $15,000 in DR/DO Passenger-Paid Fares. Please confirm that this is not a rounded number and is based on actual data, or revise the data if needed. 0.09 0.12 85.23 85.89 475
2 1 NA You reported $16,585 under Organization-Paid Fares, Funds Expended on Operations, last Report Year. However, you reported $0 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed. 0.09 0.12 85.35 85.98 476
2 1 NA You reported $23,103 under Organization-Paid Fares, Funds Expended on Operations, last Report Year. However, you reported $0 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed. 0.09 0.12 85.47 86.07 477
2 1 NA You reported $8,734 to the Other Directly Generated Funds section. Please revise the description to include the type of funds these are. 0.09 0.12 85.60 86.17 478
2 1 NA You reported 1 facility with capital responsibility; however, 0 facilities have condition assessments reported. For 2021, you are required to report condition assessments for 100% of the facilities for which you have capital responsibility. Please provide an explanation or revise the data. 0.09 0.12 85.72 86.26 479
2 1 NA You reported 5311 Capital Expenses of $950,456, but the Urban report has those funds under operating expenses. Please revise or explain. 0.09 0.12 85.85 86.35 480
2 1 NA You reported CMAQ funds under Funds Received from Other USDOT Grant Programs. If these were flexed into 5311, please report to the FTA Formula Grants for Rural Areas line item. 0.09 0.12 85.97 86.44 481
2 1 NA You reported FTA State of Good Repair Program (§5337) funds expended on operations this year, but did not report in the prior year. Please explain or revise. 0.09 0.12 86.10 86.54 482
2 1 NA You reported Other Directly Generated Funds described as a contract between HTA and the university for fares. Can you touch on this further and if this amount represents organization paid fares? 0.09 0.12 86.22 86.63 483
2 1 NA You reported Other Directly Generated Funds on the report. Please describe the funds placed in the line. 0.09 0.12 86.34 86.72 484
2 1 NA You reported Other Federal Funds described as FHWA/FLAP/NPS-DOI. The Federal Highway funds (FHWA/FLAP) should be reported to Funds Received from Other USDOT Grant Programs. Please revise. 0.09 0.12 86.47 86.82 485
2 1 NA You reported Other Funds ($25,783) in the Non-Federal Funding Data, Funds Expended on Capital section described as TDA Local Transportation Funds. Please revise to Local Funds if these derived from a local source or State Funds if derived from a state source. 0.09 0.12 86.59 86.91 486
2 1 NA You reported Other Funds ($31,903) in the Non-Federal Funding Data described as Interest Income. Please revise to the Other Directly Generated Funds section. 0.09 0.12 86.72 87.00 487
2 1 NA You reported Other Funds ($51,858) in the Non-Federal Funding Data described as rent and revenues. Please revise these to the Other Directly Generated Funds section. 0.09 0.12 86.84 87.09 488
2 1 NA You reported Other Funds ($620) in the Non-Federal Funding Data described as CalAct membership fee. This sounds more like an expense the agency paid rather than a funding source. Please explain this type of fund further. 0.09 0.12 86.96 87.19 489
2 1 NA You reported Other Funds ($70,448) in the Non-Federal Funding Data, Funds Expended on Operations section described as lease and rent revenues. Please revise to the Other Directly Generated Funds section. 0.09 0.12 87.09 87.28 490
2 1 NA

You reported Other Funds described as ’IRS CNG rebate, CNG fuel sales, Asset gains and LAIF interest” on the RR-20.

Please: - Describe the IRS CNG rebate further, - Report the CNG fuel sales to Other Directly Generated, - Describe the asset gains further. Is this the sale of assets or capital gains that have not been expended? - Describe LAIF interest. If this is Local or State source, please revise accordingly.
0.09 0.12 87.21 87.37 491
2 1 NA You reported Other Funds described as Contract Revenues. Please report to the Other Directly Generated Funds line. 0.09 0.12 87.34 87.47 492
2 1 NA You reported Other Funds described as Contract Revenues. Please revise these to Other Directly Generated Funds. 0.09 0.12 87.46 87.56 493
2 1 NA You reported Other Funds described as Contract Revenues. Please revise to Other Directly Generated Funds. 0.09 0.12 87.59 87.65 494
2 1 NA You reported Other Funds described as Donations. Please move this to Other Directly Generated Funds. 0.09 0.12 87.71 87.74 495
2 1 NA You reported Other Funds described as Local Funds TDA Funds. Please revise to Local Funds if these derived from a local source or State Funds if derived from a state source. 0.09 0.12 87.83 87.84 496
2 1 NA You reported Other Funds described as SB1 funds. Please describe these further. If they are State Funds, please revise to that line item. 0.09 0.12 87.96 87.93 497
2 1 NA You reported Other Funds described as Transportation Development Act (TDA) Gas Tax funds. If these are State TDA Funds, please revise to State Funds. 0.09 0.12 88.08 88.02 498
2 1 NA You reported Other Funds described as a reimbursement from Kern County for CARES Act eligible operating expenses. Can you explain this funding source further? 0.09 0.12 88.21 88.12 499
2 1 NA You reported Other Funds described as revenues generated from a lease on a cell tower and rent collected for a building on the property. Please revise to Other Directly Generated. 0.09 0.12 88.33 88.21 500
2 1 NA You reported a Bus target of 100% this year, but none of the Buses (0%) have met or exceeded their ULB. This indicates that you plan that all Buses will come out of a State of Good Repair next year. Please explain or revise. 0.09 0.12 88.45 88.30 501
2 1 NA You reported a Cutaway target of 0% but 34.62% of the Cutaways have met or exceed their useful life. This indicates that you plan that all Cutaways will come into a State of Good Repair next year, but the narrative does not indicate such. Please confirm this target is what you intend to report or revise. 0.09 0.12 88.58 88.39 502
2 1 NA You reported a Cutaway target of 0% but 39.13% of the Cutaways have met or exceed their useful life. This indicates that you plan that all Cutaways will come into a State of Good Repair next year, but the narrative does not indicate such. Please confirm this target is what you intend to report or revise. 0.09 0.12 88.70 88.49 503
2 1 NA You reported a Cutaway target of 0% this year, but all Cutaways (100%) have met or exceeded their ULB. This indicates that you plan that all Cutaways will come into a State of Good Repair next year. Please explain or revise. 0.09 0.12 88.83 88.58 504
2 1 NA You reported a Cutaway target of 60% this year, but none of the Cutaways (0%) have met or exceeded their ULB. This indicates that you plan that 60% Cutaways will come out of a State of Good Repair next year. Please explain or revise. 0.09 0.12 88.95 88.67 505
2 1 NA You reported a Minivan target of 0% but all Minivans (100%) have met or exceed their useful life. This indicates that you plan that all Minivans will come into a State of Good Repair next year, but the narrative does not indicate such. Please confirm this target is what you intend to report or revise. 0.09 0.12 89.08 88.77 506
2 1 NA You reported a Minivan target of 0% this year, but all Minivans (100%) have met or exceeded their ULB. This indicates that you plan that all Minivans will come into a State of Good Repair next year. Please explain or revise. 0.09 0.12 89.20 88.86 507
2 1 NA You reported a Minivan target of 0% this year, but the Minivan (100%) has met or exceeded their ULB. This indicates that you plan that the Minivan will come into a State of Good Repair next year. Please explain or revise. 0.09 0.12 89.32 88.95 508
2 1 NA You reported a Van target of 0% this year, but the Van in the inventory looks to have met its ULB. Please explain or revise. 0.09 0.12 89.45 89.04 509
2 1 NA You reported a new DR fleet (387560) with the funding source of OF, but no federal funds expended on capital on the RR-20 form. Please explain or revise. 0.09 0.12 89.57 89.14 510
2 1 NA You reported a new fleet (392197) with RAFP funding, but no 5311 funds were reported on the RR-20. If this fleet was purchased with 5339, please report the funding source as OF. If purchased with non federal funds, please report as NFPA. 0.09 0.12 89.70 89.23 511
2 1 NA You reported a new fleet in the MB A-30 form (387521) with the funding source of NFPA, but there are no Non-Federal funding sources on capital listed on the RR-20 form. Please explain or revise. 0.09 0.12 89.82 89.32 512
2 1 NA You reported a new service truck (RVI 25592) with 0% transit agency capital responsibility. Please explain or revise. If the agency owns the vehicle, please revise to 100%. 0.09 0.12 89.94 89.42 513
2 1 NA You reported a performance target of 0.00% for Rolling Stock: MV - Minivan. However, you reported 0 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2022, divided by the total number of vehicles with useful life benchmarks. So the target of 0.00% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 90.07 89.51 514
2 1 NA You reported a performance target of 15.38% for Rolling Stock: CU - Cutaway. However, you reported 8 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 15.38% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 90.19 89.60 515
2 1 NA You reported a performance target of 25.00% for Rolling Stock: CU - Cutaway. However, you reported 5 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 25.00% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 90.32 89.69 516
2 1 NA You reported a performance target of 28.01% for Equipment: Trucks and other Rubber Tire Vehicles. However, you reported 8 service vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 28.01% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 90.44 89.79 517
2 1 NA You reported a performance target of 33.30% for Rolling Stock: VN - Van. However, you reported 1 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2022, divided by the total number of vehicles with useful life benchmarks. So the target of 33.30% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 90.56 89.88 518
2 1 NA You reported a performance target of 33.33% for Equipment: Automobiles. However, you reported 2 service vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 33.33% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 90.69 89.97 519
2 1 NA You reported a performance target of 33.33% for Rolling Stock: BU - Bus. However, you reported 4 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 33.33% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 90.81 90.06 520
2 1 NA You reported a performance target of 36.00% for Rolling Stock: CU - Cutaway. However, you reported 8 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 36.00% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 90.94 90.16 521
2 1 NA You reported a performance target of 40.00% for Rolling Stock: CU - Cutaway. However, you reported 4 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 40.00% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 91.06 90.25 522
2 1 NA You reported a performance target of 80.00% for Rolling Stock: BU - Bus. However, you reported 6 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2022, divided by the total number of vehicles with useful life benchmarks. So the target of 80.00% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.12 91.19 90.34 523
2 1 NA You reported a performance target of 87.50% for Rolling Stock: VN - Van. However, you reported 4 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2022, divided by the total number of vehicles with useful life benchmarks. So the target of 87.50% does not appear to be consistent with your current inventory. Please confirm this is what you intended to report. 0.09 0.12 91.31 90.44 524
2 1 NA You reported a portion of the Other Directly Generated Funds as medical transports. Please describe this funding source further. 0.09 0.12 91.43 90.53 525
2 1 NA You reported a target for Administrative / Maintenance Facilities on the A-90 Form; however, you are not reporting facilities with this type on the A-15 Form for which your agency has capital responsibility. 0.09 0.12 91.56 90.62 526
2 1 NA You reported a target for Automobiles on the A-90 Form; however, you are not reporting service vehicles with this vehicle type on the A-35 Form. Please provide an explanation or revise the data. 0.09 0.12 91.68 90.71 527
2 1 NA You reported a target for Automobiles on the A-90 form, but the agency retired the service vehicle and will not have one for RY2022. Please either select N/A or confirm the agency may have another service vehicle to report next year. 0.09 0.12 91.81 90.81 528
2 1 NA You reported a target for Cutaway of 1%. However, you reported three Cutaways on the A-30 form. The performance target should be the number of vehicles that you expect to be past their useful life in FY2021, divided by the total number of vehicles with ULBs. So the target of 1% does not seem logical. Please explain or revise. 0.09 0.12 91.93 90.90 529
2 1 NA You reported a target for Other on the A-90 Form; however, you are not reporting revenue vehicles with this vehicle type on the A-30 Form. Please provide an explanation or revise the data. 0.09 0.12 92.05 90.99 530
2 1 NA You reported a target for Passenger / Parking Facilities on the A-90 Form; however, you are not reporting facilities with this type on the A-15 Form for which your agency has capital responsibility. 0.09 0.12 92.18 91.09 531
2 1 NA You reported a target for Steel Wheel Vehicles on the A-90 Form; however, you are not reporting service vehicles with this vehicle type on the A-35 Form. Please provide an explanation or revise the data. 0.09 0.12 92.30 91.18 532
2 1 NA You reported a target for Steel Wheel Vehicles on the A-90 Form; however, you are not reporting service vehicles with this vehicle type on the A-35 Form. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.12 92.43 91.27 533
2 1 NA You reported a target for Trucks and other Rubber Tire Vehicles on the A-90 Form; however, you are not reporting service vehicles with this vehicle type on the A-35 Form. Please provide an explanation or revise the data. 0.09 0.12 92.55 91.36 534
2 1 NA You reported a target for Van on the A-90 Form; however, you are not reporting revenue vehicles with this vehicle type on the A-30 Form. Please provide an explanation or revise the data. 0.09 0.12 92.68 91.46 535
2 2 NA You reported a target for Van on the A-90 Form; however, you are not reporting revenue vehicles with this vehicle type on the A-30 Form. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.19 0.12 92.80 91.64 536
2 1 NA You reported an Automobile target of 100% for the 2014 service vehicle. Please explain/confirm this target is correct or revise. 0.09 0.12 92.92 91.74 537
2 1 NA You reported an owned maintenance facility this year on the A-10 form, but last year this was reported as leased. Please explain this change or revise. 0.09 0.12 93.05 91.83 538
2 1 NA You reported capital expenses to the Demand Response mode and not the Bus mode, but you added a new fleet to the Bus inventory. Should the capital expenses be moved to the Bus mode? Please revise or explain. 0.09 0.12 93.17 91.92 539
2 1 NA You reported five new fleets this year (392557, 392558, 392559, 392560, 392561) to the MB A-30 form. Four of these fleets have the funding source of NFPA and one has RAFP, but the RR-20 form only shows $76,003 of Non Federal Public Funds. If fleets were purchased with 5311, please revise the funding source to RAFP. Please revise or explain. 0.09 0.12 93.30 92.01 540
2 1 NA You reported funds expended from FTA State of Good Repair Program (§5337) for both operations and capital. Please explain or revise. 0.09 0.12 93.42 92.11 541
2 1 NA You reported new fleets to the DR A-30 form with the funding source of EMSID (386673, 386674, 386675, 386676), but there are no 5310 funds expended on capital on the RR-20 form. Please either revise the funding source, revise the RR-20 form, or explain. 0.09 0.12 93.54 92.20 542
2 1 NA You reported nine new fleets to the DR A-30 form, but the DR mode has the lowest amount of capital expenses between all three modes. Please confirm this is correct or revise. 0.09 0.12 93.67 92.29 543
2 1 NA You reported one incident and one injury. Please confirm the injury required immediate medical attention away from the scene or revise. 0.09 0.12 93.79 92.39 544
2 1 NA

You reported one incident on the RR-20 form. Please confirm this meets at least on threshold or revise.

• Property damage equal to or exceeding $25,000 • Collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle • An evacuation of a transit facility or vehicle for life safety reasons
0.09 0.12 93.92 92.48 545
2 1 NA

You reported one incident on the RR-20. Please confirm this meets one of the thresholds in the Policy Manual or revise.

• Property damage equal to or exceeding $25,000 • Collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle • An evacuation of a transit facility or vehicle for life safety reasons.
0.09 0.12 94.04 92.57 546
2 1 NA You reported one incident with one injury. Please confirm that this injury required immediate medical attention away from the scene or revise. 0.09 0.12 94.17 92.66 547
2 1 NA You reported one incident with one injury. Please confirm the injury required immediate attention away from the scene. 0.09 0.12 94.29 92.76 548
2 1 NA You reported one maintenance facility Owned By Service Provider this year, but last year reported this as Owned by Public Agency for Service Provider. Please explain or revise. 0.09 0.12 94.41 92.85 549
2 1 NA You reported one maintenance facility owned by the service provider this year, but reported the maintenance facility as owned by your public agency last year. Please either explain or revise. 0.09 0.12 94.54 92.94 550
2 1 NA You reported that MB was the primary mode for both A-15 facilities, but the MB A-10 does not have the highest allocation of the three modes. Please revise. 0.09 0.12 94.66 93.04 551
2 1 NA You reported that SV-3 has 0 total vehicles but is not retired. Can you explain this situation further or revise? 0.09 0.12 94.79 93.13 552
2 1 NA You reported the 2018 Big Tex Trailer has an estimated cost of $5,500. This seems low. Please confirm this estimated cost is correct or revise. 0.09 0.12 94.91 93.22 553
2 1 NA You reported the Van target of 0% in the Rolling Stock section of the A-90, but the 2003 Van on the A-30 form has met its useful life. Please explain or revise. 0.09 0.12 95.03 93.31 554
2 1 NA You reported the capital expenses per mode based on exact percentages of the total capital expense. Demand Response is exactly 26% and Motor Bus is exactly 74%. Agencies should report actual expenses per mode and if a capital expense is incurred for both modes, report that capital expense to just one mode. 0.09 0.12 95.16 93.41 555
2 1 NA You reported the maintenance facility as owned last year, but are reporting it as leased this year. Please explain further. 0.09 0.12 95.28 93.50 556
2 1 NA You reported the same amount of capital expenses ($191,556) for both the MB and CB modes. This is highly unusual. Please explain or revise to the actual amount of capital expense per mode. 0.09 0.12 95.41 93.59 557
2 1 NA

You reported three incidents on the RR-20 form. Please confirm these meet at least one threshold defined in the Policy Manual or revise.

• Property damage equal to or exceeding $25,000 • Collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle • An evacuation of a transit facility or vehicle for life safety reasons
0.09 0.12 95.53 93.69 558
2 1 NA

You reported two incidents on the RR-20. Please confirm these meet at least one threshold or revise.

• Property damage equal to or exceeding $25,000 • Collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle • An evacuation of a transit facility or vehicle for life safety reasons.
0.09 0.12 95.65 93.78 559
2 1 NA

You reported two incidents on the RR-20. Please confirm these meet one of the thresholds listed in the policy manual or revise.

• Property damage equal to or exceeding $25,000 • Collisions involving transit revenue vehicles that require towing away from the scene for a transit roadway vehicle or other non-transit roadway vehicle • An evacuation of a transit facility or vehicle for life safety reasons.
0.09 0.12 95.78 93.87 560
2 1 NA You reported two new fleets this year in both modes (386932, 386933) with the funding source of OF, but not federal funds are reported on capital. If these vehicles were purchased with Local or State Funds, please revise the funding source to NFPA. If not, please explain. 0.09 0.12 95.90 93.96 561
2 1 NA You reported two total maintenance facilities between the A-10 forms, but only reported one last year. Please explain or revise. 0.09 0.12 96.03 94.06 562
2 1 NA You reported your Cares Act Rural Area Programs Funds under the Indian Reservations Programs Funds line item. Please revise to CARES Act Rural Area Program Funds (§5311). 0.09 0.12 96.15 94.15 563
2 1 NA You reported your organization type as City, County or Local Government Unit or Department of Transportation on your Urban/Tribal Subrecipient B-10 form; however the subrecipient reported their organization type as Independent Public Agency or Authority of Transit Service on their B-10 form. These organization types should match. Please revise your organization type on the B-10 or provide a detailed explanation. 0.09 0.12 96.28 94.24 564
2 1 NA You stated that San Benito LTA suspended all fare collection from March 2020 until June 15, 2021. With the agency suspending fare collection for all but two weeks of the fiscal year, please explain the $19,962 reported for CB Fare Revenue. 0.09 0.12 96.40 94.34 565
2 1 NA You stated that San Benito LTA suspended all fare collection from March 2020 until June 15, 2021. With the agency suspending fare collection for all but two weeks of the fiscal year, please explain the $35,933 reported for DR Fare Revenue. 0.09 0.12 96.52 94.43 566
2 1 NA Your Narrative Report states that the Minivan target is 100% but you reported the target as 0%. Please explain or revise. 0.09 0.12 96.65 94.52 567
2 1 NA Your have reported a useful life benchmark of 13 for Van RVI ID(s) 337939, which is outside of the expected tolerance. Please confirm this is the expected lifecycle of this asset in your agency’s operating environment. 0.09 0.12 96.77 94.61 568
2 1 NA Your have reported a useful life benchmark of 14 for Van RVI ID(s) 379161, which is outside of the expected tolerance. Please confirm this is the expected lifecycle of this asset in your agency’s operating environment. 0.09 0.12 96.90 94.71 569
2 1 NA Your have reported a useful life benchmark of 20 for Cutaway RVI ID(s) 316503, which is outside of the expected tolerance. Please confirm this is the expected lifecycle of this asset in your agency’s operating environment. 0.09 0.12 97.02 94.80 570
2 1 NA Your have reported a useful life benchmark of 7 for Bus RVI ID(s) 341759, which is outside of the expected tolerance. Please confirm this is the expected lifecycle of this asset in your agency’s operating environment. 0.09 0.12 97.14 94.89 571
2 1 NA Your have reported a useful life benchmark of 7 for Bus RVI ID(s) 350296, 350297, 350295, which is outside of the expected tolerance. Please confirm this is the expected lifecycle of this asset in your agency’s operating environment. 0.09 0.12 97.27 94.99 572
2 1 NA Your have reported a useful life benchmark of 7 for Bus RVI ID(s) 381536, which is outside of the expected tolerance. Please confirm this is the expected lifecycle of this asset in your agency’s operating environment. 0.09 0.12 97.39 95.08 573
2 1 NA Your have reported a useful life benchmark of 8 for Bus RVI IDs 350261, 350263, and 350265 which is outside of the expected tolerance. Please confirm this is the expected lifecycle of this asset in your agency’s operating environment. 0.09 0.12 97.52 95.17 574
1 6 A30-028 RVI ID {} does not show any active vehicles in the fleet. If these vehicles were not part of the total fleet on the last day of the fiscal year, this fleet should be retired. If they were part of the total fleet but were not in active service, please verify this. 0.56 0.06 97.58 95.73 575
1 1 A30-044 RVI ID {} 0.09 0.06 97.64 95.82 576
1 2 RR20F-010 Fare Revenues, Funds Expended on Operations plus Capital is {} last report year. 0.19 0.06 97.70 96.01 577
1 2 RR20F-066 FTA Formula Grants for Rural Areas (5311), Funds Expended on Operations plus Capital is {} last report year. 0.19 0.06 97.77 96.19 578
1 1 RR20F-069 The funds expended on §5311 program are equal to the Total Expenses. This grant program requires a match from state or local sources. 0.09 0.06 97.83 96.29 579
1 2 RR20F-070 The §5311 program is not listed as a revenue source in your report. 0.19 0.06 97.89 96.47 580
1 2 RR20F-072 5311 - capital assistance spent on operations is {} last report year. 0.19 0.06 97.95 96.66 581
1 2 RR20F-127 Other Federal Funds, Funds Expended on Operations plus Capital is {} last report year. 0.19 0.06 98.01 96.84 582
1 1 RR20F-146 The calculated miles per vehicle for {} caused by a change in Vehicle Revenue Miles, the number of Vehicles Operated in Annual Maximum Service, or both. 0.09 0.06 98.08 96.94 583
1 1 RR20F-173 The number of incidents per mile is high compared to industry standards. Please confirm. 0.09 0.06 98.14 97.03 584
1 2 RR20F-180 The total Vehicles Operated in Annual Maximum Service on the RR-20 form {}. Please revise. 0.19 0.06 98.20 97.21 585
1 1 NA

A30-094 - For DR/PT, you have selected No Capital Replacement Responsibility for RVI ID(s) 387817, 388572, 388573, 388575, however, the funding type is Enhanced Mobility of Seniors & Individuals with Disabilities (EMSID). This is unusual. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below.

A30-094 - For MB/PT, you have selected No Capital Replacement Responsibility for RVI ID(s) 388576, 388577, 388578, however, the funding type is Rural Area Formula Program (RAFP). This is unusual. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below.
0.09 0.06 98.26 97.31 586
1 1 NA Cares Act Rural Area Program Funds (§5311) ($66,262) from the subrecipient RR-20 Reduced Reporting Form does not equal Cares Act Rural Area Program Funds (§5311) Funds Expended on Operations ($0) on the Urban form. These values should match. Please explain or revise the data. 0.09 0.06 98.32 97.40 587
1 1 NA Does the agency only receive 5311f funding? Is this a feeder service or true intercity bus service? 0.09 0.06 98.39 97.49 588
1 1 NA Fleet 360323 (Cutaway) is listed with the ULB of 10 years, yet the Sponsors Narrative Report stated that Cutaways in the plan have a ULB of seven years. Please either revise or explain. 0.09 0.06 98.45 97.59 589
1 1 NA Fleet 381848 (Bus) is listed with the ULB of 14 years, yet all other Buses are listed with 12 years and the Sponsors Narrative Report stated that Buses in the plan have a ULB of 12 years. Please either revise or explain. 0.09 0.06 98.51 97.68 590
1 1 NA

For DR/DO, you reported $33,465 under Organization-Paid Fares, Funds Expended on Operations, last Report Year. However, you reported $0 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed.

For MB/DO, you reported $16,235 under Organization-Paid Fares, Funds Expended on Operations, last Report Year. However, you reported $0 this report year. Please provide an explanation for this change in Organization-Paid Fares, or revise the data if needed.
0.09 0.06 98.57 97.77 591
1 1 NA

In Report Year 2021, FTA issued the following note on the State’s Closeout Letter:

“Subrecipient 91093 - City of Eureka reported identical Operating Expenses for its DR/PT mode ($790,440) in RY 2020 and 2021. You stated that the City designated the seller of service, Humboldt Transit Authority (HTA), as the recipient of its share of FTA 5311 Rural Area Formula Program funds. Because HTA applies for and administers the 5311 funds for the contracted service on the City’s behalf, you stated that the City does not incur any contract administration costs associated with this service. However, if City employees perform any degree of labor for the provision of this service, including compiling data for the annual NTD report, those internal labor costs must be included in the annual Operating Expenses. Please note that you should not report identical Operating Expenses for this subrecipient’s DR/PT mode again in RY 2023.”

Please confirm this issue has been resolved for RY22, or provide more information.
0.09 0.06 98.63 97.86 592
1 1 NA Please revise to select N/A for all the asset classes your agency does not have, rather than reporting a 0% target. 0.09 0.06 98.70 97.96 593
1 1 NA The Demand Response Fare Revenue per Passenger decreased 39% since last year and the Motor Bus Fare Revenue per Passenger increased 26%. Please explain or revise. 0.09 0.06 98.76 98.05 594
1 1 NA The calculated cost per mile for DR/PT equals ($26.99) for the current report year and equals ($20.05) in the previous report year. That is a (34.61%) change, which is high. Cost per mile is the operating expenses by mode divided by VRM on the RR-20. Please explain or revise the data. 0.09 0.06 98.82 98.14 595
1 1 NA The calculated cost per mile for MB/PT equals ($3.66) for the current report year and equals ($3.00) in the previous report year. That is a (22.00%) change, which is high. Cost per mile is the operating expenses by mode divided by VRM on the RR-20. Please explain or revise the data. 0.09 0.06 98.88 98.24 596
1 1 NA

This agency reported $107,814 under FTA Formula Grants for Rural Areas (§5311) in their direct urban report.

You reported $107,814 under CRRSA Act Rural Area Program Funds (§5311) in this urban subrecipient report.

Please coordinate with this agency to determine the correct funding program, and revise the data if needed.
0.09 0.06 98.94 98.33 597
1 1 NA Vehicle Revenue Miles (9,128) for this agency changed -67.1% since last year (27,761). please revise the data or explain. 0.09 0.06 99.01 98.42 598
1 1 NA You did not report a target for Cutaway on the A-90 Form; however, you are reporting revenue vehicle fleets with this vehicle type of the A-30 Form. Please provide an explanation or revise the data. 0.09 0.06 99.07 98.51 599
1 1 NA You have reported one owned maintenance facility on the A-10 form, but no maintenance facilities listed on the A-15 form. This is unusual. Please explain or revise. 0.09 0.06 99.13 98.61 600
1 1 NA You have selected No Capital Replacement Responsibility for RVI ID(s) 388573, 388574, 387817, 388575, 388572, however, the funding type is Enhanced Mobility of Seniors & Individuals with Disabilities (EMSID). This is unusual. Please provide an explanation or revise the data. 0.09 0.06 99.19 98.70 601
1 1 NA You have selected No Capital Replacement Responsibility for RVI ID(s) 388575, 388572, 387817, 388573, 388574, however, the funding type is Enhanced Mobility of Seniors & Individuals with Disabilities (EMSID). This is unusual. Please provide an explanation or revise the data. 0.09 0.06 99.26 98.79 602
1 1 NA You have selected No Capital Replacement Responsibility for RVI ID(s) 388578, 388576, 388577, however, the funding type is Rural Area Formula Program (RAFP). This is unusual. Please provide an explanation or revise the data. 0.09 0.06 99.32 98.89 603
1 1 NA You reported a Bus target of 0% this year, but 50% of the Buses have met or exceed their useful life. Please explain or revise. 0.09 0.06 99.38 98.98 604
1 1 NA You reported a Condition Assessment of 5, Excellent for Facility ID 3551, Maintenance Shop; however, the year built or reconstructed as new (2002) indicates this facility is 18 years old. This is unusual. Please provide an explanation or revise the data. 0.09 0.06 99.44 99.07 605
1 1 NA You reported a Condition Assessment of 5, Excellent for Facility ID 3551, Maintenance Shop; however, the year built or reconstructed as new (2002) indicates this facility is 20 years old. This is unusual. Please provide an explanation or update the data on the associated form. 0.09 0.06 99.50 99.16 606
1 2 NA You reported a performance target of 33.33% for Rolling Stock: BU - Bus. However, you reported 4 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 33.33% does not seem to be logical. Please confirm this is what you intended to report. 0.19 0.06 99.57 99.35 607
1 1 NA You reported a performance target of 40.00% for Rolling Stock: CU - Cutaway. However, you reported 4 revenue vehicles of this type with useful life benchmarks. Your performance target should be the number of vehicles that you expect to be past their useful life in fiscal year 2021, divided by the total number of vehicles with useful life benchmarks. So the target of 40.00% does not seem to be logical. Please confirm this is what you intended to report. 0.09 0.06 99.63 99.44 608
1 1 NA You reported a target for Bus on the A-90 Form; however, you are not reporting revenue vehicles with this vehicle type on the A-30 Form. Please provide an explanation or revise the data. 0.09 0.06 99.69 99.54 609
1 1 NA You reported a target for Bus on the A-90 Form; however, you are not reporting revenue vehicles with this vehicle type on the A-30 Form. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.06 99.75 99.63 610
1 1 NA You reported a target for Trucks and other Rubber Tire Vehicles on the A-90 Form; however, you are not reporting service vehicles with this vehicle type on the A-35 Form. Please provide an explanation or update the data on the associated form. If you update the data on the form, please explain what you changed in the comment box below. 0.09 0.06 99.81 99.72 611
1 1 NA You reported an Automobiles target of 0%, but the Automobiles performance is 100% for the one 1992 vehicle. Please explain the target or revise. 0.09 0.06 99.88 99.81 612
1 1 NA You reported one maintenance facility on the A-15 but none on the A-10 forms. Please explain. 0.09 0.06 99.94 99.91 613
1 1 NA You reported the Cutaway target of 0% in the Rolling Stock section of the A-90, but the the Cutaway performance this year is 44.44%. Please explain or revise. 0.09 0.06 100.00 100.00 614

Final Recommendations: The Prioritized Validation Issue List

Finally, we take a combination of the issues that are most numerous, and those that have the most comments to curate a list of 23 prioritized issues. These are the ones that were cross-checked manually lenthy_convos and streamlined_qs, and by human judgement can be done within project time.

The top 23 Prioritized NTD validation flags
no. Issue.Check.ID descr_stripped n pct_total cumulative_pct prioritized
1 RR20F-005 The calculated cost per hour for {} Percent. 95 8.52 8.52 yes
2 A10-033 Number of General Purpose Maintenance Facilities is {} last report year. 91 8.16 16.68 yes
3 RR20F-146 The calculated miles per vehicle for {} caused by a change in Vehicle Revenue Miles, the number of Vehicles Operated in Annual Maximum Service, or both. 90 8.07 24.75 yes
4 A30-028 RVI ID {} does not show any active vehicles in the fleet. If these vehicles were not part of the total fleet on the last day of the fiscal year, this fleet should be retired. If they were part of the total fleet but were not in active service, please verify this. 51 4.57 29.33 yes
5 RR20F-001OA You reported $ {} for Total Operating Expenses by Source and did not report capital leasing expenses. These values must match. 51 4.57 33.90 yes
6 RR20F-008 Fare Revenues per unlinked passenger trip {}. This change is high. 51 4.57 38.48 yes
7 RR20F-070 The §5311 program is not listed as a revenue source in your report. 40 3.59 42.06 yes
8 RR20F-179 One or more service data fields are are missing for {}. You must report miles, hours, trips and vehicles operated in maximum service (VOMS) if the transit unit operated revenue service during the fiscal year. 40 3.59 45.65 yes
9 RR20F-139 For {}. This change is high. 39 3.50 49.15 yes
10 A10-032 The total maintenance facilities {} you reported across all modes does not add up to a whole number. 38 3.41 52.56 yes
11 RR20F-066 FTA Formula Grants for Rural Areas (5311), Funds Expended on Operations plus Capital is {} last report year. 37 3.32 55.87 yes
12 RR20F-137 For {}. This change is high. 37 3.32 59.19 yes
13 RR20F-154 The calculated trips per hour for {}. This change is high. 37 3.32 62.51 yes
14 RR20F-171 For {} this year. 32 2.87 65.38 yes
15 RR20F-001C The sum of Total Expenses for all modes {} for Uses of Capital. Total Expenses by Mode must equal the total of all funding source expenditures for capital purchases. 28 2.51 67.89 yes
16 RR20F-180 The total Vehicles Operated in Annual Maximum Service on the RR-20 form {}. Please revise. 25 2.24 70.13 yes
17 RR20F-065 FTA Formula Grants for Rural Areas (5311) {} is identical to last year’s report. This is unusual as financial data typically fluctuates from year to year. 24 2.15 72.29 yes
18 RR20F-010 Fare Revenues, Funds Expended on Operations plus Capital is {} last report year. 21 1.88 74.17 yes
19 RR20U-005 FTA Formula Grants for Rural Areas (§5311), Funds Expended on Operations plus Capital, is {} last report year. 20 1.79 75.96 yes
20 RR20F-182 Sum of Funds Expended on Capital for all modes on the RR-20 form equals zero, but {} new fleets were reported as Owned Outright by Public Agency (OOPA). 17 1.52 77.49 yes
21 RR20F-143 For {} last report year. 16 1.43 78.92 yes
48 A30-002 Number of Vehicles in Total Fleet is null for RVI ID {}. 2 0.18 96.77 yes
64 RR20F-013 Other Directly Generated Funds {} are identical to last year’s report. This is unusual as financial data typically fluctuates from year to year. 1 0.09 99.28 yes